APPS.ENGPKIMP dependencies on WIP_OPERATIONS

Line 2132: FROM wip_operations o,

2128: p_operation_seq_num NUMBER,
2129: p_organization_id NUMBER)
2130: IS
2131: SELECT 'X'
2132: FROM wip_operations o,
2133: wip_discrete_jobs w
2134: WHERE w.wip_entity_id = p_from_wip_entity_id
2135: AND w.status_type = 1
2136: AND o.wip_entity_id = w.wip_entity_id

Line 2163: FROM wip_operations wo

2159: AND we.organization_id = p_organization_id
2160: AND status_type = 1
2161: AND NOT EXISTS (
2162: SELECT 1
2163: FROM wip_operations wo
2164: WHERE wo.wip_entity_id = we.wip_entity_id
2165: AND operation_seq_num = p_operation_seq_num
2166: )
2167: );

Line 2185: FROM wip_operations wo

2181: AND wdj.primary_item_id = item.revised_item_id
2182: AND wdj.organization_Id = item.organization_id
2183: AND NOT EXISTS (
2184: SELECT 1
2185: FROM wip_operations wo
2186: WHERE wo.wip_entity_id = wdj.wip_entity_id
2187: AND operation_seq_num = p_operation_seq_num
2188: )
2189: );