APPS.EAM_WO_CHANGE_STATUS_PVT dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 803: FROM PO_REQUISITIONS_INTERFACE_ALL PRI

799: AND PRL.LINE_LOCATION_ID is NULL
800: AND nvl(PRL.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED') /*12392266, FP of 8286428*/
801: UNION ALL
802: SELECT 1
803: FROM PO_REQUISITIONS_INTERFACE_ALL PRI
804: WHERE PRI.WIP_ENTITY_ID = l_wip_entity_id
805: AND PRI.DESTINATION_ORGANIZATION_ID = l_organization_id
806: ) ;
807:

Line 1232: FROM PO_REQUISITIONS_INTERFACE_ALL PRI

1228: AND nvl(PRL.cancel_flag, 'N') = 'N'
1229: --AND PRL.LINE_LOCATION_ID is NULL
1230: UNION ALL
1231: SELECT 'PO/REQ Linked'
1232: FROM PO_REQUISITIONS_INTERFACE_ALL PRI
1233: WHERE PRI.WIP_ENTITY_ID = p_wip_entity_id
1234: AND PRI.DESTINATION_ORGANIZATION_ID = p_organization_id
1235: AND (p_op_seq_num is NULL OR PRI.WIP_OPERATION_SEQ_NUM = p_op_seq_num)
1236: AND (p_res_seq_num is NULL OR PRI.WIP_RESOURCE_SEQ_NUM = p_res_seq_num)