eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AR_RECEIVABLES_TRX_ED_L_V

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

View Text

SELECT /*+ INDEX(HE AR_XLA_LINES_EXTRACT_N1) */ RTAE.ASSET_TAX_CODE ED_ACT_ASSET_TAX_CODE
, RTAE.ATTRIBUTE1 ED_ACT_ATTR1
, RTAE.ATTRIBUTE10 ED_ACT_ATTR10
, RTAE.ATTRIBUTE11 ED_ACT_ATTR11
, RTAE.ATTRIBUTE12 ED_ACT_ATTR12
, RTAE.ATTRIBUTE13 ED_ACT_ATTR13
, RTAE.ATTRIBUTE14 ED_ACT_ATTR14
, RTAE.ATTRIBUTE15 ED_ACT_ATTR15
, RTAE.ATTRIBUTE2 ED_ACT_ATTR2
, RTAE.ATTRIBUTE3 ED_ACT_ATTR3
, RTAE.ATTRIBUTE4 ED_ACT_ATTR4
, RTAE.ATTRIBUTE5 ED_ACT_ATTR5
, RTAE.ATTRIBUTE6 ED_ACT_ATTR6
, RTAE.ATTRIBUTE7 ED_ACT_ATTR7
, RTAE.ATTRIBUTE8 ED_ACT_ATTR8
, RTAE.ATTRIBUTE9 ED_ACT_ATTR9
, RTAE.ATTRIBUTE_CATEGORY ED_ACT_ATTR_CAT
, RTAE.CODE_COMBINATION_ID ED_ACT_CODE_COMBINATION_ID
, RTAE.DEFAULT_ACCTG_DISTRIBUTION_SET ED_ACT_DEF_ACCT_DISTRIB_SET
, RTAE.DESCRIPTION ED_ACT_DESCRIPTION
, RTAE.GL_ACCOUNT_SOURCE ED_ACT_GL_ACCOUNT_SOURCE
, RTAE.LIABILITY_TAX_CODE ED_ACT_LIABILITY_TAX_CODE
, RTAE.NAME ED_ACT_NAME
, RTAE.RECEIVABLES_TRX_ID ED_ACT_RECEIVABLES_TRX_ID
, RTAE.TAX_CODE_SOURCE ED_ACT_TAX_CODE_SOURCE
, RTAE.TAX_RECOVERABLE_FLAG ED_ACT_TAX_RECOVERABLE_FLAG
, RTAE.TYPE ED_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 RTAE
, AR_XLA_LINES_EXTRACT HE
WHERE RTAE.RECEIVABLES_TRX_ID = HE.ED_ADJ_RECEIVABLES_TRX_ID
AND HE.LEVEL_FLAG = 'L'
AND RTAE.ORG_ID = HE.ORG_ID GROUP BY RTAE.ASSET_TAX_CODE
, RTAE.ATTRIBUTE1
, RTAE.ATTRIBUTE10
, RTAE.ATTRIBUTE11
, RTAE.ATTRIBUTE12
, RTAE.ATTRIBUTE13
, RTAE.ATTRIBUTE14
, RTAE.ATTRIBUTE15
, RTAE.ATTRIBUTE2
, RTAE.ATTRIBUTE3
, RTAE.ATTRIBUTE4
, RTAE.ATTRIBUTE5
, RTAE.ATTRIBUTE6
, RTAE.ATTRIBUTE7
, RTAE.ATTRIBUTE8
, RTAE.ATTRIBUTE9
, RTAE.ATTRIBUTE_CATEGORY
, RTAE.CODE_COMBINATION_ID
, RTAE.DEFAULT_ACCTG_DISTRIBUTION_SET
, RTAE.DESCRIPTION
, RTAE.GL_ACCOUNT_SOURCE
, RTAE.LIABILITY_TAX_CODE
, RTAE.NAME
, RTAE.RECEIVABLES_TRX_ID
, RTAE.TAX_CODE_SOURCE
, RTAE.TAX_RECOVERABLE_FLAG
, RTAE.TYPE
, HE.EVENT_ID
, HE.LINE_NUMBER
, HE.LANGUAGE
, HE.LEDGER_ID

Columns

Name
ED_ACT_ASSET_TAX_CODE
ED_ACT_ATTR1
ED_ACT_ATTR10
ED_ACT_ATTR11
ED_ACT_ATTR12
ED_ACT_ATTR13
ED_ACT_ATTR14
ED_ACT_ATTR15
ED_ACT_ATTR2
ED_ACT_ATTR3
ED_ACT_ATTR4
ED_ACT_ATTR5
ED_ACT_ATTR6
ED_ACT_ATTR7
ED_ACT_ATTR8
ED_ACT_ATTR9
ED_ACT_ATTR_CAT
ED_ACT_CODE_COMBINATION_ID
ED_ACT_DEF_ACCT_DISTRIB_SET
ED_ACT_DESCRIPTION
ED_ACT_GL_ACCOUNT_SOURCE
ED_ACT_LIABILITY_TAX_CODE
ED_ACT_NAME
ED_ACT_RECEIVABLES_TRX_ID
ED_ACT_TAX_CODE_SOURCE
ED_ACT_TAX_RECOVERABLE_FLAG
ED_ACT_TYPE
EVENT_ID
LINE_NUMBER
LANGUAGE
LEDGER_ID