Product: | AR - Receivables |
---|---|
Description: | receivable activity shared extract |
Implementation/DBA Data: | APPS.AR_RECEIVABLES_TRX_ACT_S_V |
SELECT /*+ INDEX(HE AR_XLA_LINES_EXTRACT_N1) */ REC_ACT.ASSET_TAX_CODE REC_ACT_ASSET_TAX_CODE
, REC_ACT.ATTRIBUTE1 REC_ACT_ATTR1
, REC_ACT.ATTRIBUTE10 REC_ACT_ATTR10
, REC_ACT.ATTRIBUTE11 REC_ACT_ATTR11
, REC_ACT.ATTRIBUTE12 REC_ACT_ATTR12
, REC_ACT.ATTRIBUTE13 REC_ACT_ATTR13
, REC_ACT.ATTRIBUTE14 REC_ACT_ATTR14
, REC_ACT.ATTRIBUTE15 REC_ACT_ATTR15
, REC_ACT.ATTRIBUTE2 REC_ACT_ATTR2
, REC_ACT.ATTRIBUTE3 REC_ACT_ATTR3
, REC_ACT.ATTRIBUTE4 REC_ACT_ATTR4
, REC_ACT.ATTRIBUTE5 REC_ACT_ATTR5
, REC_ACT.ATTRIBUTE6 REC_ACT_ATTR6
, REC_ACT.ATTRIBUTE7 REC_ACT_ATTR7
, REC_ACT.ATTRIBUTE8 REC_ACT_ATTR8
, REC_ACT.ATTRIBUTE9 REC_ACT_ATTR9
, REC_ACT.ATTRIBUTE_CATEGORY REC_ACT_ATTR_CAT
, REC_ACT.CODE_COMBINATION_ID REC_ACT_CODE_COMBINATION_ID
, REC_ACT.DEFAULT_ACCTG_DISTRIBUTION_SET REC_ACT_DEF_ACCT_DISTRIB_SET
, REC_ACT.DESCRIPTION REC_ACT_DESCRIPTION
, REC_ACT.GL_ACCOUNT_SOURCE REC_ACT_GL_ACCOUNT_SOURCE
, REC_ACT.LIABILITY_TAX_CODE REC_ACT_LIABILITY_TAX_CODE
, REC_ACT.NAME REC_ACT_NAME
, REC_ACT.RECEIVABLES_TRX_ID REC_ACT_RECEIVABLES_TRX_ID
, REC_ACT.TAX_CODE_SOURCE REC_ACT_TAX_CODE_SOURCE
, REC_ACT.TAX_RECOVERABLE_FLAG REC_ACT_TAX_RECOVERABLE_FLAG
, REC_ACT.TYPE REC_ACT_TYPE
, HE.EVENT_ID EVENT_ID
, HE.LINE_NUMBER LINE_NUMBER
, HE.LEDGER_ID LEDGER_ID
FROM AR_RECEIVABLES_TRX_ALL REC_ACT
, AR_XLA_LINES_EXTRACT HE
WHERE REC_ACT.RECEIVABLES_TRX_ID = HE.RECEIVABLES_TRX_ID
AND REC_ACT.ORG_ID = HE.ORG_ID
AND ((HE.EVENT_CLASS_CODE IN ('ADJUSTMENT'
, 'BILL')
AND HE.LEVEL_FLAG = 'H') OR (HE.EVENT_CLASS_CODE IN ('RECEIPT'
, 'CREDIT_MEMO')
AND HE.LEVEL_FLAG = 'L'))