[Home] [Help]
View: 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
Name |
TRANSACTION_ID |
REGISTER |
ORGANIZATION_ID |
LOCATION_ID |
FIN_YEAR |
SLNO |
REGISTER_ID |
EXCISE_INVOICE_NUMBER |
EXCISE_INVOICE_DATE |
CREATION_DATE |
CREDIT |
CESS_CREDIT |
DEBIT |
CESS_DEBIT |