[Home] [Help]
View: JAI_RCV_ACCNT_HDR_V
View Text
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
Columns
Name |
ORGANIZATION_CODE |
RECEIPT_NUM |
TRANSACTION_TYPE |
TRANSACTION_ID |
TRANSACTION_DATE |
LINE_NUM |
ACCT_NATURE |
ACCT_TYPE |
QUANTITY |
UOM |
ITEM_ID |
ORGANIZATION_ID |