DBA Data[Home] [Help]

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 101: FROM OE_ORDER_HEADERS_ALL OEH,

97: PRL.QUANTITY_DELIVERED,
98: PRL.ITEM_ID,
99: PRL.DESTINATION_ORGANIZATION_ID,
100: PRL.DESTINATION_SUBINVENTORY
101: FROM OE_ORDER_HEADERS_ALL OEH,
102: PO_REQUISITION_LINES_ALL PRL
103: WHERE OEH.HEADER_ID = L_HEADER_ID
104: AND OEH.SOURCE_DOCUMENT_ID = PRL.REQUISITION_HEADER_ID;
105: