VIEW: APPS.JAI_RCV_RG_QUANTITY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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