eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_RES_USAGE_SUBSTITUTIONS dependencies on WIP_CONSTANTS

Line 17: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

13: p_organization_id number) IS
14: SELECT operation_seq_num, resource_seq_num
15: FROM WIP_JOB_DTLS_INTERFACE
16: WHERE group_id = p_group_id
17: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
18: AND process_status = WIP_CONSTANTS.RUNNING
19: AND wip_entity_id = p_wip_entity_id
20: AND organization_id = p_organization_id
21: AND load_type = WIP_JOB_DETAILS.WIP_RES_USAGE

Line 18: AND process_status = WIP_CONSTANTS.RUNNING

14: SELECT operation_seq_num, resource_seq_num
15: FROM WIP_JOB_DTLS_INTERFACE
16: WHERE group_id = p_group_id
17: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
18: AND process_status = WIP_CONSTANTS.RUNNING
19: AND wip_entity_id = p_wip_entity_id
20: AND organization_id = p_organization_id
21: AND load_type = WIP_JOB_DETAILS.WIP_RES_USAGE
22: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD