DBA Data[Home] [Help]

APPS.WIP_RES_USAGE_SUBSTITUTIONS dependencies on WIP_JOB_DTLS_INTERFACE

Line 15: FROM WIP_JOB_DTLS_INTERFACE

11: Cursor Usage_info (p_group_id number,
12: p_wip_entity_id number,
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

Line 56: FROM WIP_JOB_DTLS_INTERFACE

52: resource_seq_num, start_date, completion_date, assigned_units,
53: last_update_date, last_updated_by, creation_date, created_by,
54: last_update_login, program_application_id, request_id, program_id,
55: program_update_date, substitution_type
56: FROM WIP_JOB_DTLS_INTERFACE
57: WHERE group_id = p_group_id
58: AND wip_entity_id = p_wip_entity_id
59: AND organization_id = p_organization_id
60: AND operation_seq_num = p_operation_seq_num