DBA Data[Home] [Help]

APPS.JA_JAINVATR_XMLP_PKG dependencies on RCV_TRANSACTIONS

Line 127: RCV_TRANSACTIONS RT

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
131: AND RT.SOURCE_DOCUMENT_CODE = 'REQ'