DBA Data[Home] [Help]

APPS.EAM_WO_CHANGE_STATUS_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 1219: PO_REQUISITION_HEADERS_ALL PRH

1215:
1216: CURSOR disc_check_po_req_cur IS
1217: SELECT 'PO/REQ Linked'
1218: FROM PO_REQUISITION_LINES_ALL PRL,
1219: PO_REQUISITION_HEADERS_ALL PRH
1220: WHERE PRL.requisition_header_id = PRH.requisition_header_id(+)
1221: AND upper(NVL(PRH.authorization_status, 'APPROVED') ) not in ('CANCELLED', 'REJECTED','SYSTEM_SAVED')
1222: AND PRL.WIP_ENTITY_ID = p_wip_entity_id
1223: AND PRL.DESTINATION_ORGANIZATION_ID = p_organization_id