You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!