View: AR_TRANSACTIONS_S_V

Product:	AR - Receivables
Description:	transaction shared extract
Implementation/DBA Data:	APPS.AR_TRANSACTIONS_S_V

View Text

SELECT /*+ INDEX(L AR_XLA_LINES_EXTRACT_N1) */ CTAF.ATTRIBUTE1 TRX_ATTR1
, CTAF.ATTRIBUTE10 TRX_ATTR10
, CTAF.ATTRIBUTE11 TRX_ATTR11
, CTAF.ATTRIBUTE12 TRX_ATTR12
, CTAF.ATTRIBUTE13 TRX_ATTR13
, CTAF.ATTRIBUTE14 TRX_ATTR14
, CTAF.ATTRIBUTE15 TRX_ATTR15
, CTAF.ATTRIBUTE2 TRX_ATTR2
, CTAF.ATTRIBUTE3 TRX_ATTR3
, CTAF.ATTRIBUTE4 TRX_ATTR4
, CTAF.ATTRIBUTE5 TRX_ATTR5
, CTAF.ATTRIBUTE6 TRX_ATTR6
, CTAF.ATTRIBUTE7 TRX_ATTR7
, CTAF.ATTRIBUTE8 TRX_ATTR8
, CTAF.ATTRIBUTE9 TRX_ATTR9
, CTAF.ATTRIBUTE_CATEGORY TRX_ATTR_CAT
, CTAF.CREDIT_METHOD_FOR_INSTALLMENTS TRX_CREDIT_METHOD_FOR_INSTALL
, CTAF.CREDIT_METHOD_FOR_RULES TRX_CREDIT_METHOD_FOR_RULES
, CTAF.CUSTOMER_TRX_ID TRX_CUSTOMER_TRX_ID
, CTAF.DOC_SEQUENCE_ID TRX_DOC_SEQUENCE_ID
, CTAF.DOC_SEQUENCE_VALUE TRX_DOC_SEQUENCE_VALUE
, DECODE(CTAF.DOC_SEQUENCE_VALUE
, NULL
, NULL
, CTTAF.NAME) TRX_DOC_SEQUENCE_CATEGORY
, CTAF.FOB_POINT TRX_FOB_POINT
, CTAF.GLOBAL_ATTRIBUTE1 TRX_GLOBAL_ATTR1
, CTAF.GLOBAL_ATTRIBUTE10 TRX_GLOBAL_ATTR10
, CTAF.GLOBAL_ATTRIBUTE11 TRX_GLOBAL_ATTR11
, CTAF.GLOBAL_ATTRIBUTE12 TRX_GLOBAL_ATTR12
, CTAF.GLOBAL_ATTRIBUTE13 TRX_GLOBAL_ATTR13
, CTAF.GLOBAL_ATTRIBUTE14 TRX_GLOBAL_ATTR14
, CTAF.GLOBAL_ATTRIBUTE15 TRX_GLOBAL_ATTR15
, CTAF.GLOBAL_ATTRIBUTE16 TRX_GLOBAL_ATTR16
, CTAF.GLOBAL_ATTRIBUTE17 TRX_GLOBAL_ATTR17
, CTAF.GLOBAL_ATTRIBUTE18 TRX_GLOBAL_ATTR18
, CTAF.GLOBAL_ATTRIBUTE19 TRX_GLOBAL_ATTR19
, CTAF.GLOBAL_ATTRIBUTE2 TRX_GLOBAL_ATTR2
, CTAF.GLOBAL_ATTRIBUTE20 TRX_GLOBAL_ATTR20
, CTAF.GLOBAL_ATTRIBUTE3 TRX_GLOBAL_ATTR3
, CTAF.GLOBAL_ATTRIBUTE4 TRX_GLOBAL_ATTR4
, CTAF.GLOBAL_ATTRIBUTE5 TRX_GLOBAL_ATTR5
, CTAF.GLOBAL_ATTRIBUTE6 TRX_GLOBAL_ATTR6
, CTAF.GLOBAL_ATTRIBUTE7 TRX_GLOBAL_ATTR7
, CTAF.GLOBAL_ATTRIBUTE8 TRX_GLOBAL_ATTR8
, CTAF.GLOBAL_ATTRIBUTE9 TRX_GLOBAL_ATTR9
, CTAF.GLOBAL_ATTRIBUTE_CATEGORY TRX_GLOBAL_ATTR_CAT
, CTAF.INTERFACE_HEADER_ATTRIBUTE1 TRX_INTERFACE_HEADER_ATTR1
, CTAF.INTERFACE_HEADER_ATTRIBUTE10 TRX_INTERFACE_HEADER_ATTR10
, CTAF.INTERFACE_HEADER_ATTRIBUTE11 TRX_INTERFACE_HEADER_ATTR11
, CTAF.INTERFACE_HEADER_ATTRIBUTE12 TRX_INTERFACE_HEADER_ATTR12
, CTAF.INTERFACE_HEADER_ATTRIBUTE13 TRX_INTERFACE_HEADER_ATTR13
, CTAF.INTERFACE_HEADER_ATTRIBUTE14 TRX_INTERFACE_HEADER_ATTR14
, CTAF.INTERFACE_HEADER_ATTRIBUTE15 TRX_INTERFACE_HEADER_ATTR15
, CTAF.INTERFACE_HEADER_ATTRIBUTE2 TRX_INTERFACE_HEADER_ATTR2
, CTAF.INTERFACE_HEADER_ATTRIBUTE3 TRX_INTERFACE_HEADER_ATTR3
, CTAF.INTERFACE_HEADER_ATTRIBUTE4 TRX_INTERFACE_HEADER_ATTR4
, CTAF.INTERFACE_HEADER_ATTRIBUTE5 TRX_INTERFACE_HEADER_ATTR5
, CTAF.INTERFACE_HEADER_ATTRIBUTE6 TRX_INTERFACE_HEADER_ATTR6
, CTAF.INTERFACE_HEADER_ATTRIBUTE7 TRX_INTERFACE_HEADER_ATTR7
, CTAF.INTERFACE_HEADER_ATTRIBUTE8 TRX_INTERFACE_HEADER_ATTR8
, CTAF.INTERFACE_HEADER_ATTRIBUTE9 TRX_INTERFACE_HEADER_ATTR9
, CTAF.INTERFACE_HEADER_CONTEXT TRX_INTERFACE_HEADER_CT
, CTAF.INVOICE_CURRENCY_CODE TRX_INVOICE_CURRENCY_CODE
, CTAF.INVOICING_RULE_ID TRX_INVOICING_RULE_ID
, CTAF.PRINTING_OPTION TRX_PRINTING_OPTION
, CTAF.PURCHASE_ORDER TRX_PURCHASE_ORDER
, CTAF.PURCHASE_ORDER_DATE TRX_PURCHASE_ORDER_DATE
, CTAF.PURCHASE_ORDER_REVISION TRX_PURCHASE_ORDER_REVISION
, CTAF.REASON_CODE TRX_REASON_CODE
, CTAF.SHIP_DATE_ACTUAL TRX_SHIP_DATE_ACTUAL
, CTAF.STATUS_TRX TRX_STATUS_TRX
, CTAF.TERM_DUE_DATE TRX_TERM_DUE_DATE
, CTAF.TRX_DATE TRX_DATE
, CTAF.TRX_NUMBER TRX_NUMBER
, CTAF.WAYBILL_NUMBER TRX_WAYBILL_NUMBER
, CTTAF.CUST_TRX_TYPE_ID TRX_TYPE_CUST_TRX_TYPE_ID
, CTTAF.DESCRIPTION TRX_TYPE_DESCRIPTION
, CTTAF.DRAWEE_ISSUED_FLAG TRX_TYPE_DRAWEE_ISSUED_FLAG
, CTTAF.GLOBAL_ATTRIBUTE1 TRX_TYPE_GLOBAL_ATTR1
, CTTAF.GLOBAL_ATTRIBUTE10 TRX_TYPE_GLOBAL_ATTR10
, CTTAF.GLOBAL_ATTRIBUTE2 TRX_TYPE_GLOBAL_ATTR2
, CTTAF.GLOBAL_ATTRIBUTE3 TRX_TYPE_GLOBAL_ATTR3
, CTTAF.GLOBAL_ATTRIBUTE4 TRX_TYPE_GLOBAL_ATTR4
, CTTAF.GLOBAL_ATTRIBUTE5 TRX_TYPE_GLOBAL_ATTR5
, CTTAF.GLOBAL_ATTRIBUTE6 TRX_TYPE_GLOBAL_ATTR6
, CTTAF.GLOBAL_ATTRIBUTE7 TRX_TYPE_GLOBAL_ATTR7
, CTTAF.GLOBAL_ATTRIBUTE_CATEGORY TRX_TYPE_GLOBAL_ATTR_CAT
, CTTAF.GL_ID_REV TRX_TYPE_DEP_OFFSET_CCID
, CTTAF.GL_ID_CLEARING TRX_TYPE_CLEARING_CCID
, CTTAF.GL_ID_FACTOR TRX_TYPE_FACTOR_CCID
, CTTAF.GL_ID_FREIGHT TRX_TYPE_FREIGHT_CCID
, CTTAF.GL_ID_REC TRX_TYPE_REC_CCID
, CTTAF.GL_ID_REMITTANCE TRX_TYPE_REMITTANCE_CCID
, CTTAF.GL_ID_REV TRX_TYPE_REV_CCID
, CTTAF.GL_ID_TAX TRX_TYPE_TAX_CCID
, CTTAF.GL_ID_UNBILLED TRX_TYPE_UNBILLED_CCID
, CTTAF.GL_ID_UNEARNED TRX_TYPE_UNEARNED_CCID
, CTTAF.GL_ID_UNPAID_REC TRX_TYPE_UNPAID_REC_CCID
, CTTAF.MAGNETIC_FORMAT_CODE TRX_TYPE_MAG_FORMAT_CODE
, CTTAF.NAME TRX_TYPE_NAME
, CTTAF.POST_TO_GL TRX_TYPE_POST_TO_GL
, CTTAF.TYPE TRX_TYPE_CLASS
, TF.DESCRIPTION TER_DESCRIPTION
, TF.NAME TER_NAME
, TF.SEGMENT1 TER_SEGMENT1
, TF.SEGMENT10 TER_SEGMENT10
, TF.SEGMENT11 TER_SEGMENT11
, TF.SEGMENT12 TER_SEGMENT12
, TF.SEGMENT13 TER_SEGMENT13
, TF.SEGMENT14 TER_SEGMENT14
, TF.SEGMENT15 TER_SEGMENT15
, TF.SEGMENT16 TER_SEGMENT16
, TF.SEGMENT17 TER_SEGMENT17
, TF.SEGMENT18 TER_SEGMENT18
, TF.SEGMENT19 TER_SEGMENT19
, TF.SEGMENT2 TER_SEGMENT2
, TF.SEGMENT20 TER_SEGMENT20
, TF.SEGMENT3 TER_SEGMENT3
, TF.SEGMENT4 TER_SEGMENT4
, TF.SEGMENT5 TER_SEGMENT5
, TF.SEGMENT6 TER_SEGMENT6
, TF.SEGMENT7 TER_SEGMENT7
, TF.SEGMENT8 TER_SEGMENT8
, TF.SEGMENT9 TER_SEGMENT9
, TF.SUMMARY_FLAG TER_SUMMARY_FLAG
, TF.TERRITORY_ID TER_TERRITORY_ID
, L.EVENT_ID EVENT_ID
, L.LINE_NUMBER LINE_NUMBER
, L.LEDGER_ID LEDGER_ID
, 'C' XLA_PARTY_TYPE
, CTAF.ORG_ID TRX_OPER_UNIT
, L.PAIRED_CCID TRX_RECEIVABLE_CCID
, NVL(CTAF.APPLICATION_ID
, 222) TRX_XLA_APPLIED_TO_APP_ID
, DECODE(L.EVENT_CLASS_CODE
, 'BILL'
, 'BILLS_RECEIVABLE'
, 'TRANSACTIONS') TRX_ENTITY_CODE
, CTAF.LEGAL_ENTITY_ID
FROM RA_CUSTOMER_TRX_ALL CTAF
, RA_CUST_TRX_TYPES_ALL CTTAF
, RA_TERRITORIES TF
, RA_RULES RARHF
, AR_XLA_LINES_EXTRACT L
WHERE CTAF.CUSTOMER_TRX_ID = L.CUSTOMER_TRX_ID
AND CTAF.INVOICING_RULE_ID = RARHF.RULE_ID (+)
AND CTAF.CUST_TRX_TYPE_ID = CTTAF.CUST_TRX_TYPE_ID (+)
AND CTAF.ORG_ID = CTTAF.ORG_ID (+)
AND CTAF.TERRITORY_ID = TF.TERRITORY_ID (+)
AND ((L.EVENT_CLASS_CODE IN ('INVOICE'
, 'DEBIT_MEMO'
, 'DEPOSIT'
, 'GUARANTEE'
, 'CHARGEBACK'
, 'ADJUSTMENT'
, 'BILL')
AND L.LEVEL_FLAG = 'H') OR (L.EVENT_CLASS_CODE IN ('CREDIT_MEMO'
, 'RECEIPT')
AND L.LEVEL_FLAG = 'L'
AND L.FROM_TO_FLAG = 'T'))

Columns