View: AR_RECEIVABLES_TRX_MISC_H_V

Product:	AR - Receivables
Description:	miscellaneous cash receipt receivable activity header extract
Implementation/DBA Data:	APPS.AR_RECEIVABLES_TRX_MISC_H_V

View Text

SELECT /*+INDEX(HE AR_XLA_LINES_EXTRACT_N1) */ RTAM.ASSET_TAX_CODE MC_ACT_ASSET_TAX_CODE
, RTAM.ATTRIBUTE1 MC_ACT_ATTR1
, RTAM.ATTRIBUTE10 MC_ACT_ATTR10
, RTAM.ATTRIBUTE11 MC_ACT_ATTR11
, RTAM.ATTRIBUTE12 MC_ACT_ATTR12
, RTAM.ATTRIBUTE13 MC_ACT_ATTR13
, RTAM.ATTRIBUTE14 MC_ACT_ATTR14
, RTAM.ATTRIBUTE15 MC_ACT_ATTR15
, RTAM.ATTRIBUTE2 MC_ACT_ATTR2
, RTAM.ATTRIBUTE3 MC_ACT_ATTR3
, RTAM.ATTRIBUTE4 MC_ACT_ATTR4
, RTAM.ATTRIBUTE5 MC_ACT_ATTR5
, RTAM.ATTRIBUTE6 MC_ACT_ATTR6
, RTAM.ATTRIBUTE7 MC_ACT_ATTR7
, RTAM.ATTRIBUTE8 MC_ACT_ATTR8
, RTAM.ATTRIBUTE9 MC_ACT_ATTR9
, RTAM.ATTRIBUTE_CATEGORY MC_ACT_ATTR_CAT
, RTAM.CODE_COMBINATION_ID MC_ACT_CODE_COMBINATION_ID
, RTAM.DEFAULT_ACCTG_DISTRIBUTION_SET MC_ACT_DEF_ACCT_DISTRIB_SET
, RTAM.DESCRIPTION MC_ACT_DESCRIPTION
, RTAM.GL_ACCOUNT_SOURCE MC_ACT_GL_ACCOUNT_SOURCE
, RTAM.LIABILITY_TAX_CODE MC_ACT_LIABILITY_TAX_CODE
, RTAM.NAME MC_ACT_NAME
, RTAM.RECEIVABLES_TRX_ID MC_ACT_RECEIVABLES_TRX_ID
, RTAM.TAX_CODE_SOURCE MC_ACT_TAX_CODE_SOURCE
, RTAM.TAX_RECOVERABLE_FLAG MC_ACT_TAX_RECOVERABLE_FLAG
, RTAM.TYPE MC_ACT_TYPE
, HE.EVENT_ID EVENT_ID
FROM AR_RECEIVABLES_TRX_ALL RTAM
, AR_XLA_LINES_EXTRACT HE
WHERE RTAM.RECEIVABLES_TRX_ID = HE.RECEIVABLES_TRX_ID
AND HE.LEVEL_FLAG = 'H'
AND RTAM.ORG_ID = HE.ORG_ID

Columns