DBA Data[Home] [Help]

APPS.JA_JAINVATR_XMLP_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 126: PO_REQUISITION_LINES_ALL PRLA,

122: CURSOR LCU_ISO_RECEIPTS_AMOUNT IS
123: SELECT
124: SUM(PRLA.UNIT_PRICE * RT.PRIMARY_QUANTITY)
125: FROM
126: PO_REQUISITION_LINES_ALL PRLA,
127: RCV_TRANSACTIONS RT
128: WHERE PRLA.REQUISITION_LINE_ID = RT.REQUISITION_LINE_ID
129: AND PRLA.DESTINATION_ORGANIZATION_ID = A_ORGANIZATION_ID
130: AND PRLA.DELIVER_TO_LOCATION_ID = A_LOCATION_ID