APPS.ENGPKIMP dependencies on WIP_OPERATIONS

Line 2228: FROM wip_operations o,

2224: p_operation_seq_num NUMBER,
2225: p_organization_id NUMBER)
2226: IS
2227: SELECT 'X'
2228: FROM wip_operations o,
2229: wip_discrete_jobs w
2230: WHERE w.wip_entity_id = p_from_wip_entity_id
2231: AND w.status_type = 1
2232: AND o.wip_entity_id = w.wip_entity_id

Line 2259: FROM wip_operations wo

2255: AND we.organization_id = p_organization_id
2256: AND status_type = 1
2257: AND NOT EXISTS (
2258: SELECT 1
2259: FROM wip_operations wo
2260: WHERE wo.wip_entity_id = we.wip_entity_id
2261: AND operation_seq_num = p_operation_seq_num
2262: )
2263: );

Line 2281: FROM wip_operations wo

2277: AND wdj.primary_item_id = item.revised_item_id
2278: AND wdj.organization_Id = item.organization_id
2279: AND NOT EXISTS (
2280: SELECT 1
2281: FROM wip_operations wo
2282: WHERE wo.wip_entity_id = wdj.wip_entity_id
2283: AND operation_seq_num = p_operation_seq_num
2284: )
2285: );