View: AR_CREDIT_MEMO_H_V

Product:	AR - Receivables
Description:	AR XLA Extract
Implementation/DBA Data:	APPS.AR_CREDIT_MEMO_H_V

View Text

SELECT /*+INDEX(HE AR_XLA_LINES_EXTRACT_N1)*/ CTAT.ATTRIBUTE1 CM_ATTR1
, CTAT.ATTRIBUTE10 CM_ATTR10
, CTAT.ATTRIBUTE11 CM_ATTR11
, CTAT.ATTRIBUTE12 CM_ATTR12
, CTAT.ATTRIBUTE13 CM_ATTR13
, CTAT.ATTRIBUTE14 CM_ATTR14
, CTAT.ATTRIBUTE15 CM_ATTR15
, CTAT.ATTRIBUTE2 CM_ATTR2
, CTAT.ATTRIBUTE3 CM_ATTR3
, CTAT.ATTRIBUTE4 CM_ATTR4
, CTAT.ATTRIBUTE5 CM_ATTR5
, CTAT.ATTRIBUTE6 CM_ATTR6
, CTAT.ATTRIBUTE7 CM_ATTR7
, CTAT.ATTRIBUTE8 CM_ATTR8
, CTAT.ATTRIBUTE9 CM_ATTR9
, CTAT.ATTRIBUTE_CATEGORY CM_ATTR_CAT
, CTAT.CUSTOMER_TRX_ID CM_CUSTOMER_TRX_ID
, CTAT.DEFAULT_USSGL_TRANSACTION_CODE CM_DEF_USSGL_TRX
, CTAT.DEFAULT_USSGL_TRX_CODE_CONTEXT CM_DEF_USSGL_TRX_CODE_CT
, CTAT.DOC_SEQUENCE_ID CM_DOC_SEQUENCE_ID
, CTAT.DOC_SEQUENCE_VALUE CM_DOC_SEQUENCE_VALUE
, DECODE(CTAT.DOC_SEQUENCE_VALUE
, NULL
, NULL
, CTTAT.NAME) CM_DOC_SEQUENCE_CATEGORY
, CTAT.FOB_POINT CM_FOB_POINT
, CTAT.GLOBAL_ATTRIBUTE1 CM_GLOBAL_ATTR1
, CTAT.GLOBAL_ATTRIBUTE10 CM_GLOBAL_ATTR10
, CTAT.GLOBAL_ATTRIBUTE11 CM_GLOBAL_ATTR11
, CTAT.GLOBAL_ATTRIBUTE12 CM_GLOBAL_ATTR12
, CTAT.GLOBAL_ATTRIBUTE13 CM_GLOBAL_ATTR13
, CTAT.GLOBAL_ATTRIBUTE14 CM_GLOBAL_ATTR14
, CTAT.GLOBAL_ATTRIBUTE15 CM_GLOBAL_ATTR15
, CTAT.GLOBAL_ATTRIBUTE16 CM_GLOBAL_ATTR16
, CTAT.GLOBAL_ATTRIBUTE17 CM_GLOBAL_ATTR17
, CTAT.GLOBAL_ATTRIBUTE18 CM_GLOBAL_ATTR18
, CTAT.GLOBAL_ATTRIBUTE19 CM_GLOBAL_ATTR19
, CTAT.GLOBAL_ATTRIBUTE2 CM_GLOBAL_ATTR2
, CTAT.GLOBAL_ATTRIBUTE20 CM_GLOBAL_ATTR20
, CTAT.GLOBAL_ATTRIBUTE3 CM_GLOBAL_ATTR3
, CTAT.GLOBAL_ATTRIBUTE4 CM_GLOBAL_ATTR4
, CTAT.GLOBAL_ATTRIBUTE5 CM_GLOBAL_ATTR5
, CTAT.GLOBAL_ATTRIBUTE6 CM_GLOBAL_ATTR6
, CTAT.GLOBAL_ATTRIBUTE7 CM_GLOBAL_ATTR7
, CTAT.GLOBAL_ATTRIBUTE8 CM_GLOBAL_ATTR8
, CTAT.GLOBAL_ATTRIBUTE9 CM_GLOBAL_ATTR9
, CTAT.GLOBAL_ATTRIBUTE_CATEGORY CM_GLOBAL_ATTR_CAT
, CTAT.INTERFACE_HEADER_ATTRIBUTE1 CM_INTERFACE_HEADER_ATTR1
, CTAT.INTERFACE_HEADER_ATTRIBUTE10 CM_INTERFACE_HEADER_ATTR10
, CTAT.INTERFACE_HEADER_ATTRIBUTE11 CM_INTERFACE_HEADER_ATTR11
, CTAT.INTERFACE_HEADER_ATTRIBUTE12 CM_INTERFACE_HEADER_ATTR12
, CTAT.INTERFACE_HEADER_ATTRIBUTE13 CM_INTERFACE_HEADER_ATTR13
, CTAT.INTERFACE_HEADER_ATTRIBUTE14 CM_INTERFACE_HEADER_ATTR14
, CTAT.INTERFACE_HEADER_ATTRIBUTE15 CM_INTERFACE_HEADER_ATTR15
, CTAT.INTERFACE_HEADER_ATTRIBUTE2 CM_INTERFACE_HEADER_ATTR2
, CTAT.INTERFACE_HEADER_ATTRIBUTE3 CM_INTERFACE_HEADER_ATTR3
, CTAT.INTERFACE_HEADER_ATTRIBUTE4 CM_INTERFACE_HEADER_ATTR4
, CTAT.INTERFACE_HEADER_ATTRIBUTE5 CM_INTERFACE_HEADER_ATTR5
, CTAT.INTERFACE_HEADER_ATTRIBUTE6 CM_INTERFACE_HEADER_ATTR6
, CTAT.INTERFACE_HEADER_ATTRIBUTE7 CM_INTERFACE_HEADER_ATTR7
, CTAT.INTERFACE_HEADER_ATTRIBUTE8 CM_INTERFACE_HEADER_ATTR8
, CTAT.INTERFACE_HEADER_ATTRIBUTE9 CM_INTERFACE_HEADER_ATTR9
, CTAT.INTERFACE_HEADER_CONTEXT CM_INTERFACE_HEADER_CT
, CTAT.INVOICE_CURRENCY_CODE CM_INVOICE_CURRENCY_CODE
, CTAT.INVOICING_RULE_ID CM_INVOICING_RULE_ID
, CTAT.PRINTING_OPTION CM_PRINTING_OPTION
, CTAT.PURCHASE_ORDER CM_PURCHASE_ORDER
, CTAT.PURCHASE_ORDER_DATE CM_PURCHASE_ORDER_DATE
, CTAT.PURCHASE_ORDER_REVISION CM_PURCHASE_ORDER_REVISION
, CTAT.SHIP_DATE_ACTUAL CM_SHIP_DATE_ACTUAL
, CTAT.STATUS_TRX CM_STATUS_TRX
, CTAT.TERM_DUE_DATE CM_TERM_DUE_DATE
, CTAT.TRX_DATE CM_TRX_DATE
, CTAT.TRX_NUMBER CM_TRX_NUMBER
, CTAT.WAYBILL_NUMBER CM_WAYBILL_NUMBER
, CTTAT.CUST_TRX_TYPE_ID CM_TRX_TYPE_CUST_TRX_TYPE_ID
, CTTAT.DESCRIPTION CM_TRX_TYPE_DESCRIPTION
, CTTAT.DRAWEE_ISSUED_FLAG CM_TRX_TYPE_DRAWEE_ISSUED_FLAG
, CTTAT.GLOBAL_ATTRIBUTE1 CM_TRX_TYPE_GLOBAL_ATTR1
, CTTAT.GLOBAL_ATTRIBUTE10 CM_TRX_TYPE_GLOBAL_ATTR10
, CTTAT.GLOBAL_ATTRIBUTE2 CM_TRX_TYPE_GLOBAL_ATTR2
, CTTAT.GLOBAL_ATTRIBUTE3 CM_TRX_TYPE_GLOBAL_ATTR3
, CTTAT.GLOBAL_ATTRIBUTE4 CM_TRX_TYPE_GLOBAL_ATTR4
, CTTAT.GLOBAL_ATTRIBUTE5 CM_TRX_TYPE_GLOBAL_ATTR5
, CTTAT.GLOBAL_ATTRIBUTE6 CM_TRX_TYPE_GLOBAL_ATTR6
, CTTAT.GLOBAL_ATTRIBUTE7 CM_TRX_TYPE_GLOBAL_ATTR7
, CTTAT.GLOBAL_ATTRIBUTE_CATEGORY CM_TRX_TYPE_GLOBAL_ATTR_CAT
, CTTAT.GL_ID_CLEARING CM_TRX_TYPE_CLEARING_CCID
, CTTAT.GL_ID_FACTOR CM_TRX_TYPE_FACTOR_CCID
, CTTAT.GL_ID_FREIGHT CM_TRX_TYPE_FREIGHT_CCID
, CTTAT.GL_ID_REC CM_TRX_TYPE_REC_CCID
, CTTAT.GL_ID_REMITTANCE CM_TRX_TYPE_REMITTANCE_CCID
, CTTAT.GL_ID_REV CM_TRX_TYPE_REV_CCID
, CTTAT.GL_ID_TAX CM_TRX_TYPE_TAX_CCID
, CTTAT.GL_ID_UNBILLED CM_TRX_TYPE_UNBILLED_CCID
, CTTAT.GL_ID_UNEARNED CM_TRX_TYPE_UNEARNED_CCID
, CTTAT.GL_ID_UNPAID_REC CM_TRX_TYPE_UNPAID_REC_CCID
, CTTAT.MAGNETIC_FORMAT_CODE CM_TRX_TYPE_MAG_FORMAT_CODE
, CTTAT.NAME CM_TRX_TYPE_NAME
, CTTAT.POST_TO_GL CM_TRX_TYPE_POST_TO_GL
, CTTAT.TYPE CM_TRX_TYPE_CLASS
, TT.DESCRIPTION CM_TER_DESCRIPTION
, TT.NAME CM_TER_NAME
, TT.SEGMENT1 CM_TER_SEGMENT1
, TT.SEGMENT10 CM_TER_SEGMENT10
, TT.SEGMENT11 CM_TER_SEGMENT11
, TT.SEGMENT12 CM_TER_SEGMENT12
, TT.SEGMENT13 CM_TER_SEGMENT13
, TT.SEGMENT14 CM_TER_SEGMENT14
, TT.SEGMENT15 CM_TER_SEGMENT15
, TT.SEGMENT16 CM_TER_SEGMENT16
, TT.SEGMENT17 CM_TER_SEGMENT17
, TT.SEGMENT18 CM_TER_SEGMENT18
, TT.SEGMENT19 CM_TER_SEGMENT19
, TT.SEGMENT2 CM_TER_SEGMENT2
, TT.SEGMENT20 CM_TER_SEGMENT20
, TT.SEGMENT3 CM_TER_SEGMENT3
, TT.SEGMENT4 CM_TER_SEGMENT4
, TT.SEGMENT5 CM_TER_SEGMENT5
, TT.SEGMENT6 CM_TER_SEGMENT6
, TT.SEGMENT7 CM_TER_SEGMENT7
, TT.SEGMENT8 CM_TER_SEGMENT8
, TT.SEGMENT9 CM_TER_SEGMENT9
, TT.SUMMARY_FLAG CM_TER_SUMMARY_FLAG
, TT.TERRITORY_ID CM_TER_TERRITORY_ID
, HE.EVENT_ID EVENT_ID
, HE.LEDGER_ID LEDGER_ID
, CTAT.ORG_ID CM_OPER_UNIT
, HE.PAIRED_CCID CM_RECEIVABLE_CCID
, 'C' XLA_PARTY_TYPE
, 222 CM_XLA_APPLIED_TO_APP_ID
, 'TRANSACTIONS' CM_ENTITY_CODE
, CTAT.PREVIOUS_CUSTOMER_TRX_ID CM_PRV_TRX_ID
FROM RA_CUSTOMER_TRX_ALL CTAT
, RA_CUST_TRX_TYPES_ALL CTTAT
, RA_TERRITORIES TT
, RA_RULES RARHT
, AR_XLA_LINES_EXTRACT HE
WHERE CTAT.CUSTOMER_TRX_ID = HE.CUSTOMER_TRX_ID
AND HE.LEVEL_FLAG = 'H'
AND CTAT.INVOICING_RULE_ID = RARHT.RULE_ID (+)
AND CTAT.CUST_TRX_TYPE_ID = CTTAT.CUST_TRX_TYPE_ID (+)
AND CTAT.ORG_ID = CTTAT.ORG_ID (+)
AND CTAT.TERRITORY_ID = TT.TERRITORY_ID (+)
AND HE.EVENT_TYPE_CODE IN ( 'CM_CREATE'
, 'CM_UPDATE')

Columns