APPS.CSP_REPAIR_PO_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 86: SELECT * FROM OE_ORDER_HEADERS_ALL OEH,

82: AND CRL.REPAIR_PO_HEADER_ID = CRH.REPAIR_PO_HEADER_ID;
83:
84: /*
85: CURSOR IO_QTY_RECEIVED_CHECK (L_HEADER_ID NUMBER)IS
86: SELECT * FROM OE_ORDER_HEADERS_ALL OEH,
87: OE_ORDER_LINES_ALL OEL, PO_REQUISITION_LINES_ALL PRL
88: WHERE OEH.HEADER_ID = L_HEADER_ID AND
89: OEH.HEADER_ID = OEL.HEADER_ID AND
90: OEL.SOURCE_DOCUMENT_ID = PRL.REQUISITION_HEADER_ID AND

Line 99: FROM OE_ORDER_HEADERS_ALL OEH,

95: SELECT PRL.QUANTITY_RECEIVED,
96: PRL.ITEM_ID,
97: PRL.DESTINATION_ORGANIZATION_ID,
98: PRL.DESTINATION_SUBINVENTORY
99: FROM OE_ORDER_HEADERS_ALL OEH,
100: PO_REQUISITION_LINES_ALL PRL
101: WHERE OEH.HEADER_ID = L_HEADER_ID
102: AND OEH.SOURCE_DOCUMENT_ID = PRL.REQUISITION_HEADER_ID;
103: