View: JAI_RCV_RG_AMOUNT_V

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

View Text

SELECT TO_CHAR(RECEIPT_REF) TRANSACTION_ID
, DECODE( REGISTER_TYPE
, 'A'
, 'RG23A - PARTII'
, 'RG23C - PARTII') 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
, NVL(CR_BASIC_ED
, 0) + NVL(CR_ADDITIONAL_ED
, 0) + NVL(CR_ADDITIONAL_CVD
, 0) + NVL(CR_OTHER_ED
, 0) CREDIT
, NVL(OTHER_TAX_CREDIT
, 0) OTHER_CREDIT
, NVL(DR_BASIC_ED
, 0) + NVL(DR_ADDITIONAL_ED
, 0) + NVL(DR_ADDITIONAL_CVD
, 0) + NVL(DR_OTHER_ED
, 0) DEBIT
, NVL(OTHER_TAX_DEBIT
, 0) OTHER_DEBIT
FROM JAI_CMN_RG_23AC_II_TRXS
WHERE TRANSACTION_SOURCE_NUM=18 UNION ALL SELECT TO_CHAR(REF_DOCUMENT_ID) TRANSACTION_ID
, 'PLA' REGISTER
, ORGANIZATION_ID ORGANIZATION_ID
, LOCATION_ID LOCATION_ID
, FIN_YEAR FIN_YEAR
, SLNO SLNO
, REGISTER_ID REGISTER_ID
, DR_INVOICE_NO EXCISE_INVOICE_NUMBER
, TRUNC(DR_INVOICE_DATE) EXCISE_INVOICE_DATE
, TRUNC(CREATION_DATE) CREATION_DATE
, NVL(CR_BASIC_ED
, 0) + NVL(CR_ADDITIONAL_ED
, 0) + NVL(CR_OTHER_ED
, 0) CREDIT
, NVL(OTHER_TAX_CREDIT
, 0) OTHER_CREDIT
, NVL(DR_BASIC_ED
, 0) + NVL(DR_ADDITIONAL_ED
, 0) + NVL(DR_OTHER_ED
, 0) DEBIT
, NVL(OTHER_TAX_DEBIT
, 0) OTHER_DEBIT
FROM JAI_CMN_RG_PLA_TRXS
WHERE TRANSACTION_SOURCE_NUM= 19

Columns