APPS.QA_ERES_PKG dependencies on PO_LINES_ALL

Line 186: FROM RCV_TRANSACTIONS_INTERFACE RT, MTL_SYSTEM_ITEMS MSI, PO_LINES_ALL POL

182: RETURN VARCHAR2
183: IS
184: CURSOR C1 IS
185: SELECT DECODE(rt.source_document_code, 'RMA', MSI.HAZARD_CLASS_ID, NVL(POL.HAZARD_CLASS_ID, MSI.HAZARD_CLASS_ID)) HAZARD_CLASS_ID
186: FROM RCV_TRANSACTIONS_INTERFACE RT, MTL_SYSTEM_ITEMS MSI, PO_LINES_ALL POL
187: WHERE rt.interface_transaction_id = p_interface_transaction_id AND
188: rt.to_organization_id = MSI.ORGANIZATION_ID(+) AND
189: rt.item_id = MSI.INVENTORY_ITEM_ID(+) AND
190: rt.po_line_id = POL.PO_LINE_ID(+);

Line 230: FROM RCV_TRANSACTIONS_INTERFACE RT, MTL_SYSTEM_ITEMS MSI, PO_LINES_ALL POL

226: RETURN VARCHAR2
227: IS
228: CURSOR C1 IS
229: SELECT DECODE(rt.source_document_code, 'RMA', MSI.UN_NUMBER_ID, NVL(POL.UN_NUMBER_ID, MSI.UN_NUMBER_ID)) UN_NUMBER_ID
230: FROM RCV_TRANSACTIONS_INTERFACE RT, MTL_SYSTEM_ITEMS MSI, PO_LINES_ALL POL
231: WHERE rt.interface_transaction_id = p_interface_transaction_id AND
232: rt.to_organization_id = MSI.ORGANIZATION_ID(+) AND
233: rt.item_id = MSI.INVENTORY_ITEM_ID(+) AND
234: rt.po_line_id = POL.PO_LINE_ID(+);