View: JG_ZZ_AP_CONTRA_V

Product:	JG - Regional Localizations
Description:	Subledger contra account balances for Payables
Implementation/DBA Data:	APPS.JG_ZZ_AP_CONTRA_V

View Text

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(+)

Columns