Need columns 'Destination Quick Move Phase' and 'Destination Quick Move State' in BIP Report
Summary:
I want following columns in a BIP report - Process Name, Phase, State Name, Destination Phase, Destination State and Comments. I am able to fetch all except destination phase, destination state and and Comments, there is a table IRC_LC_SETTING_ITEMS which contains ItemKeyValue column which have values as 'TargetPhaseId' and 'TargetStateId' with which we can differentiate. But, I am not able to map these two items with their setting_id with IRC_ROUTING_STEPS_B and IRC_PROCESSES_VL tables, because setting_id present in IRC_LC_SETTING_ITEMS is not present in Routing table. We have String_value column in setting table which connects with phase_id and state_id of IRC_PHASES_VL and