VIEW: APPS.JAI_RCV_ACCNT_HDR_V

Source

View Text - Preformatted

SELECT JRJ.Organization_code, JRJ.receipt_num, JRJ.transaction_type, JRJ.transaction_id, trunc(JRJ.transaction_date), RSL.line_num, JRJ.acct_nature, JRJ.acct_type, RTR.Quantity, RTR.Unit_of_measure UOM, rsl.item_id, rtr.organization_id from JAI_RCV_JOURNAL_ENTRIES JRJ, RCV_SHIPMENT_LINES RSL, RCV_TRANSACTIONS RTR WHERE JRJ.Shipment_line_id = RSL.Shipment_line_id AND JRJ.transaction_id = RTR.transaction_id AND RSL.Shipment_header_id = RTR.shipment_header_id AND RSL.Shipment_line_id = RTR.shipment_line_id GROUP BY JRJ.Organization_code, RTR.organization_id, JRJ.receipt_num, JRJ.transaction_type, JRJ.Transaction_id, trunc(JRJ.transaction_date), JRJ.acct_type, JRJ.acct_nature, RSL.line_num, RSL.Item_id, RTR.Unit_of_measure, RTR.Quantity

View Text - HTML Formatted

SELECT JRJ.ORGANIZATION_CODE
, JRJ.RECEIPT_NUM
, JRJ.TRANSACTION_TYPE
, JRJ.TRANSACTION_ID
, TRUNC(JRJ.TRANSACTION_DATE)
, RSL.LINE_NUM
, JRJ.ACCT_NATURE
, JRJ.ACCT_TYPE
, RTR.QUANTITY
, RTR.UNIT_OF_MEASURE UOM
, RSL.ITEM_ID
, RTR.ORGANIZATION_ID
FROM JAI_RCV_JOURNAL_ENTRIES JRJ
, RCV_SHIPMENT_LINES RSL
, RCV_TRANSACTIONS RTR
WHERE JRJ.SHIPMENT_LINE_ID = RSL.SHIPMENT_LINE_ID
AND JRJ.TRANSACTION_ID = RTR.TRANSACTION_ID
AND RSL.SHIPMENT_HEADER_ID = RTR.SHIPMENT_HEADER_ID
AND RSL.SHIPMENT_LINE_ID = RTR.SHIPMENT_LINE_ID GROUP BY JRJ.ORGANIZATION_CODE
, RTR.ORGANIZATION_ID
, JRJ.RECEIPT_NUM
, JRJ.TRANSACTION_TYPE
, JRJ.TRANSACTION_ID
, TRUNC(JRJ.TRANSACTION_DATE)
, JRJ.ACCT_TYPE
, JRJ.ACCT_NATURE
, RSL.LINE_NUM
, RSL.ITEM_ID
, RTR.UNIT_OF_MEASURE
, RTR.QUANTITY