View: JAI_RCV_RG_QUANTITY_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_RCV_RG_QUANTITY_V

View Text

SELECT RECEIPT_REF TRANSACTION_ID
, DECODE( REGISTER_TYPE
, 'A'
, 'RG23A - PARTI'
, 'RG23C - PARTI') REGISTER
, ORGANIZATION_ID ORGANIZATION_ID
, LOCATION_ID LOCATION_ID
, FIN_YEAR FIN_YEAR
, SLNO SLNO
, REGISTER_ID REGISTER_ID
, EXCISE_INVOICE_NO EXCISE_INVOICE_NUMBER
, TRUNC(EXCISE_INVOICE_DATE) EXCISE_INVOICE_DATE
, TRUNC(CREATION_DATE) CREATION_DATE
, PRIMARY_UOM_CODE PRIMARY_UOM
, TRANSACTION_UOM_CODE TRANSACTION_UOM
, QUANTITY_RECEIVED QUANTITY_RECEIVED
FROM JAI_CMN_RG_23AC_I_TRXS
WHERE TRANSACTION_SOURCE_NUM=18 UNION ALL SELECT REF_DOC_NO TRANSACTION_ID
, 'RG-I' REGISTER
, ORGANIZATION_ID ORGANIZATION_ID
, LOCATION_ID LOCATION_ID
, FIN_YEAR FIN_YEAR
, SLNO SLNO
, REGISTER_ID REGISTER_ID
, EXCISE_INVOICE_NUMBER EXCISE_INVOICE_NUMBER
, TRUNC(EXCISE_INVOICE_DATE) EXCISE_INVOICE_DATE
, TRUNC(CREATION_DATE) CREATION_DATE
, PRIMARY_UOM_CODE PRIMARY_UOM
, TRANSACTION_UOM_CODE TRANSACTION_UOM
, MANUFACTURED_QTY QUANTITY_RECEIVED
FROM JAI_CMN_RG_I_TRXS
WHERE TRANSACTION_SOURCE_NUM=18 UNION SELECT TO_CHAR(RECEIPT_REF) TRANSACTION_ID
, 'RG23D' REGISTER
, ORGANIZATION_ID ORGANIZATION_ID
, LOCATION_ID LOCATION_ID
, FIN_YEAR FIN_YEAR
, SLNO SLNO
, REGISTER_ID REGISTER_ID
, COMM_INVOICE_NO EXCISE_INVOICE_NUMBER
, TRUNC(COMM_INVOICE_DATE) EXCISE_INVOICE_DATE
, TRUNC(CREATION_DATE) CREATION_DATE
, PRIMARY_UOM_CODE PRIMARY_UOM
, TRANSACTION_UOM_CODE TRANSACTION_UOM
, QUANTITY_RECEIVED QUANTITY_RECEIVED
FROM JAI_CMN_RG_23D_TRXS
WHERE TRANSACTION_SOURCE_NUM=18

Columns