DBA Data[Home] [Help]

APPS.ENGPKIMP dependencies on WIP_OPERATION_RESOURCES

Line 2248: FROM wip_operation_resources wor,

2244: p_organization_id NUMBER
2245: )
2246: IS
2247: SELECT 'X'
2248: FROM wip_operation_resources wor,
2249: wip_discrete_jobs w
2250: WHERE w.wip_entity_id = p_from_wip_entity_id
2251: AND w.status_type = 1
2252: AND wor.wip_entity_id = p_from_wip_entity_id

Line 2282: FROM wip_operation_resources wor

2278: AND we.organization_id = p_organization_id
2279: AND status_type = 1
2280: AND NOT EXISTS (
2281: SELECT 1
2282: FROM wip_operation_resources wor
2283: WHERE wor.wip_entity_id = we.wip_entity_id
2284: AND wor.operation_seq_num = p_operation_seq_num
2285: AND wor.resource_seq_num = p_resource_seq_num
2286: AND wor.organization_id = p_organization_id

Line 2308: FROM wip_operation_resources wor

2304: AND wdj.organization_Id = item.organization_id
2305: AND wdj.status_type = 1
2306: AND NOT EXISTS (
2307: SELECT 1
2308: FROM wip_operation_resources wor
2309: WHERE wor.wip_entity_id = wdj.wip_entity_id
2310: AND wor.operation_seq_num = p_operation_seq_num
2311: AND wor.resource_seq_num = p_resource_seq_num
2312: AND wor.organization_id = p_organization_id