DBA Data[Home] [Help]

APPS.ENGPKIMP dependencies on WIP_OPERATION_RESOURCES

Line 2344: FROM wip_operation_resources wor,

2340: p_organization_id NUMBER
2341: )
2342: IS
2343: SELECT 'X'
2344: FROM wip_operation_resources wor,
2345: wip_discrete_jobs w
2346: WHERE w.wip_entity_id = p_from_wip_entity_id
2347: AND w.status_type = 1
2348: AND wor.wip_entity_id = p_from_wip_entity_id

Line 2378: FROM wip_operation_resources wor

2374: AND we.organization_id = p_organization_id
2375: AND status_type = 1
2376: AND NOT EXISTS (
2377: SELECT 1
2378: FROM wip_operation_resources wor
2379: WHERE wor.wip_entity_id = we.wip_entity_id
2380: AND wor.operation_seq_num = p_operation_seq_num
2381: AND wor.resource_seq_num = p_resource_seq_num
2382: AND wor.organization_id = p_organization_id

Line 2404: FROM wip_operation_resources wor

2400: AND wdj.organization_Id = item.organization_id
2401: AND wdj.status_type = 1
2402: AND NOT EXISTS (
2403: SELECT 1
2404: FROM wip_operation_resources wor
2405: WHERE wor.wip_entity_id = wdj.wip_entity_id
2406: AND wor.operation_seq_num = p_operation_seq_num
2407: AND wor.resource_seq_num = p_resource_seq_num
2408: AND wor.organization_id = p_organization_id