VIEW: APPS.JG_ZZ_AP_CONTRA_V

Source

View Text - Preformatted

SELECT JA.SET_OF_BOOKS_ID SET_OF_BOOKS_ID, JA.ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_ID, JA.CODE_COMBINATION_ID CODE_COMBINATION_ID, DECODE(CC.ACCOUNT_TYPE,'L',TO_NUMBER(NULL),(DECODE(XTREV.ENTITY_CODE,'AP_PAYMENTS',TO_NUMBER(NULL),JA.LINE_NUMBER))) LINE_NUMBER, AEL.ACCOUNTING_CLASS_CODE LINE_TYPE_CODE, JA.LINE_TYPE_FIELD LINE_TYPE, DECODE(CC.ACCOUNT_TYPE,'L',NULL,(DECODE(XTREV.ENTITY_CODE,'AP_PAYMENTS',NULL,TAX.TAX_RATE_NAME))) TAX_NAME, DECODE(CC.ACCOUNT_TYPE,'L',NULL,(DECODE(XTREV.ENTITY_CODE,'AP_PAYMENTS',NULL,AEL.DESCRIPTION))) DESCRIPTION, JA.ACCOUNT ACCOUNT, JA.ACCOUNT_DESC ACCOUNT_DESC, AEL.ENTERED_DR ENTERED_DR, AEL.ENTERED_CR ENTERED_CR, AEL.ACCOUNTED_DR ACCOUNTED_DR, AEL.ACCOUNTED_CR ACCOUNTED_CR from JG_ZZ_AP_TMP_ACCOUNT JA, (select XRE.LEDGER_ID, XRE.ENTITY_CODE, XEV.EVENT_ID from XLA_TRANSACTION_ENTITIES XRE, XLA_EVENTS XEV where XRE.APPLICATION_ID = 200 and XEV.APPLICATION_ID = 200 and XRE.ENTITY_ID = XEV.ENTITY_ID) XTREV, (select * from XLA_AE_LINES where application_id = 200) AEL, (select * from XLA_AE_HEADERS where application_id = 200) AEH, ZX_RATES_VL TAX, GL_CODE_COMBINATIONS CC WHERE AEH.LEDGER_ID = XTREV.LEDGER_ID AND AEH.EVENT_ID = JA.ACCOUNTING_EVENT_ID AND AEL.AE_HEADER_ID = AEH.AE_HEADER_ID AND AEL.AE_LINE_NUM = JA.AE_LINE_ID AND XTREV.EVENT_ID = JA.ACCOUNTING_EVENT_ID AND JA.CODE_COMBINATION_ID = CC.CODE_COMBINATION_ID and JA.TAX_CODE_ID = TAX.TAX_RATE_ID(+)

View Text - HTML Formatted

SELECT JA.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, JA.ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_ID
, JA.CODE_COMBINATION_ID CODE_COMBINATION_ID
, DECODE(CC.ACCOUNT_TYPE
, 'L'
, TO_NUMBER(NULL)
, (DECODE(XTREV.ENTITY_CODE
, 'AP_PAYMENTS'
, TO_NUMBER(NULL)
, JA.LINE_NUMBER))) LINE_NUMBER
, AEL.ACCOUNTING_CLASS_CODE LINE_TYPE_CODE
, JA.LINE_TYPE_FIELD LINE_TYPE
, DECODE(CC.ACCOUNT_TYPE
, 'L'
, NULL
, (DECODE(XTREV.ENTITY_CODE
, 'AP_PAYMENTS'
, NULL
, TAX.TAX_RATE_NAME))) TAX_NAME
, DECODE(CC.ACCOUNT_TYPE
, 'L'
, NULL
, (DECODE(XTREV.ENTITY_CODE
, 'AP_PAYMENTS'
, NULL
, AEL.DESCRIPTION))) DESCRIPTION
, JA.ACCOUNT ACCOUNT
, JA.ACCOUNT_DESC ACCOUNT_DESC
, AEL.ENTERED_DR ENTERED_DR
, AEL.ENTERED_CR ENTERED_CR
, AEL.ACCOUNTED_DR ACCOUNTED_DR
, AEL.ACCOUNTED_CR ACCOUNTED_CR
FROM JG_ZZ_AP_TMP_ACCOUNT JA
, (SELECT XRE.LEDGER_ID
, XRE.ENTITY_CODE
, XEV.EVENT_ID
FROM XLA_TRANSACTION_ENTITIES XRE
, XLA_EVENTS XEV
WHERE XRE.APPLICATION_ID = 200
AND XEV.APPLICATION_ID = 200
AND XRE.ENTITY_ID = XEV.ENTITY_ID) XTREV
, (SELECT *
FROM XLA_AE_LINES
WHERE APPLICATION_ID = 200) AEL
, (SELECT *
FROM XLA_AE_HEADERS
WHERE APPLICATION_ID = 200) AEH
, ZX_RATES_VL TAX
, GL_CODE_COMBINATIONS CC
WHERE AEH.LEDGER_ID = XTREV.LEDGER_ID
AND AEH.EVENT_ID = JA.ACCOUNTING_EVENT_ID
AND AEL.AE_HEADER_ID = AEH.AE_HEADER_ID
AND AEL.AE_LINE_NUM = JA.AE_LINE_ID
AND XTREV.EVENT_ID = JA.ACCOUNTING_EVENT_ID
AND JA.CODE_COMBINATION_ID = CC.CODE_COMBINATION_ID
AND JA.TAX_CODE_ID = TAX.TAX_RATE_ID(+)