View: AR_ADJUSTMENTS_H_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_ADJUSTMENTS_H_V

View Text

SELECT /*+INDEX (HE AR_XLA_LINES_EXTRACT_N1) */ AA.ADJUSTMENT_ID ADJ_ID
, AA.ADJUSTMENT_NUMBER ADJ_NUMBER
, AA.ADJ_TAX_ACCT_RULE ADJ_TAX_ACCT_RULE
, AA.ADJUSTMENT_TYPE ADJ_ADJ_TYPE
, AA.APPLY_DATE ADJ_APPLY_DATE
, AA.ATTRIBUTE1 ADJ_ATTR1
, AA.ATTRIBUTE10 ADJ_ATTR10
, AA.ATTRIBUTE11 ADJ_ATTR11
, AA.ATTRIBUTE12 ADJ_ATTR12
, AA.ATTRIBUTE13 ADJ_ATTR13
, AA.ATTRIBUTE14 ADJ_ATTR14
, AA.ATTRIBUTE15 ADJ_ATTR15
, AA.ATTRIBUTE2 ADJ_ATTR2
, AA.ATTRIBUTE3 ADJ_ATTR3
, AA.ATTRIBUTE4 ADJ_ATTR4
, AA.ATTRIBUTE5 ADJ_ATTR5
, AA.ATTRIBUTE6 ADJ_ATTR6
, AA.ATTRIBUTE7 ADJ_ATTR7
, AA.ATTRIBUTE8 ADJ_ATTR8
, AA.ATTRIBUTE9 ADJ_ATTR9
, AA.ATTRIBUTE_CATEGORY ADJ_ATTR_CAT
, AA.CODE_COMBINATION_ID ADJ_CODE_COMBINATION_ID
, AA.COMMENTS ADJ_COMMENTS
, AA.DISTRIBUTION_SET_ID ADJ_DISTRIB_SET_ID
, AA.DOC_SEQUENCE_ID ADJ_DOC_SEQUENCE_ID
, AA.DOC_SEQUENCE_VALUE ADJ_DOC_SEQUENCE_VALUE
, DECODE(AA.DOC_SEQUENCE_VALUE
, NULL
, NULL
, RT.NAME) ADJ_DOC_SEQUENCE_CATEGORY
, AA.GL_DATE ADJ_GL_DATE
, AA.REASON_CODE ADJ_REASON_CODE
, AA.TYPE ADJ_TYPE
, AA.USSGL_TRANSACTION_CODE ADJ_USSGL_TRX_CODE
, AA.USSGL_TRANSACTION_CODE_CONTEXT ADJ_USSGL_TRX_CODE_CT
, HE.EVENT_ID EVENT_ID
, 'C' XLA_PARTY_TYPE
, 222 ADJ_XLA_APPLIED_TO_APP_ID
, 'ADJUSTMENTS' ADJ_ENTITY_CODE
FROM AR_ADJUSTMENTS_ALL AA
, AR_RECEIVABLES_TRX_ALL RT
, AR_XLA_LINES_EXTRACT HE
WHERE AA.EVENT_ID = HE.EVENT_ID
AND RT.RECEIVABLES_TRX_ID = AA.RECEIVABLES_TRX_ID
AND AA.ORG_ID = RT.ORG_ID
AND HE.LEVEL_FLAG = 'H'

Columns