View: AR_RECEIVABLES_TRX_UNED_L_V

Product:	AR - Receivables
Description:	unearned discount activity line extract
Implementation/DBA Data:	APPS.AR_RECEIVABLES_TRX_UNED_L_V

View Text

SELECT /*+ INDEX(HE AR_XLA_LINES_EXTRACT_N1) */ RTAU.ASSET_TAX_CODE UD_ACT_ASSET_TAX_CODE
, RTAU.ATTRIBUTE1 UD_ACT_ATTR1
, RTAU.ATTRIBUTE10 UD_ACT_ATTR10
, RTAU.ATTRIBUTE11 UD_ACT_ATTR11
, RTAU.ATTRIBUTE12 UD_ACT_ATTR12
, RTAU.ATTRIBUTE13 UD_ACT_ATTR13
, RTAU.ATTRIBUTE14 UD_ACT_ATTR14
, RTAU.ATTRIBUTE15 UD_ACT_ATTR15
, RTAU.ATTRIBUTE2 UD_ACT_ATTR2
, RTAU.ATTRIBUTE3 UD_ACT_ATTR3
, RTAU.ATTRIBUTE4 UD_ACT_ATTR4
, RTAU.ATTRIBUTE5 UD_ACT_ATTR5
, RTAU.ATTRIBUTE6 UD_ACT_ATTR6
, RTAU.ATTRIBUTE7 UD_ACT_ATTR7
, RTAU.ATTRIBUTE8 UD_ACT_ATTR8
, RTAU.ATTRIBUTE9 UD_ACT_ATTR9
, RTAU.ATTRIBUTE_CATEGORY UD_ACT_ATTR_CAT
, RTAU.CODE_COMBINATION_ID UD_ACT_CODE_COMBINATION_ID
, RTAU.DEFAULT_ACCTG_DISTRIBUTION_SET UD_ACT_DEF_ACCT_DISTRIB_SET
, RTAU.DESCRIPTION UD_ACT_DESCRIPTION
, RTAU.GL_ACCOUNT_SOURCE UD_ACT_GL_ACCOUNT_SOURCE
, RTAU.LIABILITY_TAX_CODE UD_ACT_LIABILITY_TAX_CODE
, RTAU.NAME UD_ACT_NAME
, RTAU.RECEIVABLES_TRX_ID UD_ACT_RECEIVABLES_TRX_ID
, RTAU.TAX_CODE_SOURCE UD_ACT_TAX_CODE_SOURCE
, RTAU.TAX_RECOVERABLE_FLAG UD_ACT_TAX_RECOVERABLE_FLAG
, RTAU.TYPE UD_ACT_TYPE
, HE.EVENT_ID EVENT_ID
, HE.LINE_NUMBER LINE_NUMBER
, HE.LANGUAGE LANGUAGE
, HE.LEDGER_ID LEDGER_ID
FROM AR_RECEIVABLES_TRX_ALL RTAU
, AR_XLA_LINES_EXTRACT HE
WHERE RTAU.RECEIVABLES_TRX_ID = HE.UNED_RECEIVABLES_TRX_ID
AND HE.LEVEL_FLAG = 'L'
AND RTAU.ORG_ID = HE.ORG_ID GROUP BY RTAU.ASSET_TAX_CODE
, RTAU.ATTRIBUTE1
, RTAU.ATTRIBUTE10
, RTAU.ATTRIBUTE11
, RTAU.ATTRIBUTE12
, RTAU.ATTRIBUTE13
, RTAU.ATTRIBUTE14
, RTAU.ATTRIBUTE15
, RTAU.ATTRIBUTE2
, RTAU.ATTRIBUTE3
, RTAU.ATTRIBUTE4
, RTAU.ATTRIBUTE5
, RTAU.ATTRIBUTE6
, RTAU.ATTRIBUTE7
, RTAU.ATTRIBUTE8
, RTAU.ATTRIBUTE9
, RTAU.ATTRIBUTE_CATEGORY
, RTAU.CODE_COMBINATION_ID
, RTAU.DEFAULT_ACCTG_DISTRIBUTION_SET
, RTAU.DESCRIPTION
, RTAU.GL_ACCOUNT_SOURCE
, RTAU.LIABILITY_TAX_CODE
, RTAU.NAME
, RTAU.RECEIVABLES_TRX_ID
, RTAU.TAX_CODE_SOURCE
, RTAU.TAX_RECOVERABLE_FLAG
, RTAU.TYPE
, HE.EVENT_ID
, HE.LINE_NUMBER
, HE.LANGUAGE
, HE.LEDGER_ID

Columns