VIEW: APPS.AR_CREDIT_MEMO_H_V

Source

View Text - Preformatted

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 ,ctat.receipt_method_id cm_receipt_method_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')

View Text - HTML Formatted

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
, CTAT.RECEIPT_METHOD_ID CM_RECEIPT_METHOD_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')