[Home] [Help]
View: 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
Name |
TRANSACTION_ID |
REGISTER |
ORGANIZATION_ID |
LOCATION_ID |
FIN_YEAR |
SLNO |
REGISTER_ID |
EXCISE_INVOICE_NUMBER |
EXCISE_INVOICE_DATE |
CREATION_DATE |
PRIMARY_UOM |
TRANSACTION_UOM |
QUANTITY_RECEIVED |