DBA Data[Home] [Help]

APPS.WIP_RES_USAGE_DEFAULT dependencies on WIP_CONSTANTS

Line 18: AND process_phase = WIP_CONSTANTS.ML_VALIDATION

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

Line 19: AND process_status = WIP_CONSTANTS.RUNNING

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