DBA Data[Home] [Help]

APPS.AHL_OSP_ORDERS_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 848: FROM PO_REQUISITION_HEADERS_ALL POREQ, AHL_OSP_ORDERS_B OSP

844:
845: -- Added by jaramana on January 8, 2008 for the Requisition ER 6034236
846: CURSOR chk_requisition_exists_csr(c_osp_order_id IN NUMBER) IS
847: SELECT POREQ.SEGMENT1
848: FROM PO_REQUISITION_HEADERS_ALL POREQ, AHL_OSP_ORDERS_B OSP
849: WHERE POREQ.INTERFACE_SOURCE_LINE_ID = c_osp_order_id
850: AND OSP.OSP_ORDER_ID = c_osp_order_id
851: AND OSP.OPERATING_UNIT_ID = POREQ.ORG_ID
852: AND POREQ.INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME