VIEW: APPS.AR_CUST_TRX_LINES_L_V

Source

View Text - Preformatted

SELECT /*+ INDEX(l AR_XLA_LINES_EXTRACT_N1) */ ctlaf.accounting_rule_duration trx_line_acct_rule_duration ,ctlaf.amount_includes_tax_flag trx_line_amt_includes_tax_flag ,ctlaf.attribute1 trx_line_attr1 ,ctlaf.attribute10 trx_line_attr10 ,ctlaf.attribute11 trx_line_attr11 ,ctlaf.attribute12 trx_line_attr12 ,ctlaf.attribute13 trx_line_attr13 ,ctlaf.attribute14 trx_line_attr14 ,ctlaf.attribute15 trx_line_attr15 ,ctlaf.attribute2 trx_line_attr2 ,ctlaf.attribute3 trx_line_attr3 ,ctlaf.attribute4 trx_line_attr4 ,ctlaf.attribute5 trx_line_attr5 ,ctlaf.attribute6 trx_line_attr6 ,ctlaf.attribute7 trx_line_attr7 ,ctlaf.attribute8 trx_line_attr8 ,ctlaf.attribute9 trx_line_attr9 ,ctlaf.attribute_category trx_line_attr_cat ,ctlaf.customer_trx_line_id trx_line_customer_trx_line_id ,ctlaf.description trx_line_description ,ctlaf.global_attribute1 trx_line_global_attr1 ,ctlaf.global_attribute10 trx_line_global_attr10 ,ctlaf.global_attribute11 trx_line_global_attr11 ,ctlaf.global_attribute12 trx_line_global_attr12 ,ctlaf.global_attribute13 trx_line_global_attr13 ,ctlaf.global_attribute14 trx_line_global_attr14 ,ctlaf.global_attribute15 trx_line_global_attr15 ,ctlaf.global_attribute16 trx_line_global_attr16 ,ctlaf.global_attribute17 trx_line_global_attr17 ,ctlaf.global_attribute18 trx_line_global_attr18 ,ctlaf.global_attribute19 trx_line_global_attr19 ,ctlaf.global_attribute2 trx_line_global_attr2 ,ctlaf.global_attribute20 trx_line_global_attr20 ,ctlaf.global_attribute3 trx_line_global_attr3 ,ctlaf.global_attribute4 trx_line_global_attr4 ,ctlaf.global_attribute5 trx_line_global_attr5 ,ctlaf.global_attribute6 trx_line_global_attr6 ,ctlaf.global_attribute7 trx_line_global_attr7 ,ctlaf.global_attribute8 trx_line_global_attr8 ,ctlaf.global_attribute9 trx_line_global_attr9 ,ctlaf.global_attribute_category trx_line_global_attr_cat ,ctlaf.gross_unit_selling_price trx_line_gross_unit_sell_price ,ctlaf.interface_line_attribute1 trx_line_interface_line_attr1 ,ctlaf.interface_line_attribute10 trx_line_interface_line_attr10 ,ctlaf.interface_line_attribute11 trx_line_interface_line_attr11 ,ctlaf.interface_line_attribute12 trx_line_interface_line_attr12 ,ctlaf.interface_line_attribute13 trx_line_interface_line_attr13 ,ctlaf.interface_line_attribute14 trx_line_interface_line_attr14 ,ctlaf.interface_line_attribute15 trx_line_interface_line_attr15 ,ctlaf.interface_line_attribute2 trx_line_interface_line_attr2 ,ctlaf.interface_line_attribute3 trx_line_interface_line_attr3 ,ctlaf.interface_line_attribute4 trx_line_interface_line_attr4 ,ctlaf.interface_line_attribute5 trx_line_interface_line_attr5 ,ctlaf.interface_line_attribute6 trx_line_interface_line_attr6 ,ctlaf.interface_line_attribute7 trx_line_interface_line_attr7 ,ctlaf.interface_line_attribute8 trx_line_interface_line_attr8 ,ctlaf.interface_line_attribute9 trx_line_interface_line_attr9 ,ctlaf.interface_line_context trx_line_interface_line_ct ,ctlaf.item_context trx_line_item_ct ,ctlaf.line_number trx_line_line_number ,ctlaf.line_type trx_line_line_type ,ctlaf.quantity_credited trx_line_quantity_credited ,ctlaf.quantity_invoiced trx_line_quantity_invoiced ,ctlaf.quantity_ordered trx_line_quantity_ordered ,ctlaf.reason_code trx_line_reason_code ,ctlaf.rule_start_date trx_line_rule_start_date ,ctlaf.sales_order trx_line_sales_order ,ctlaf.sales_order_date trx_line_sales_order_date ,ctlaf.sales_order_line trx_line_sales_order_line ,ctlaf.sales_order_source trx_line_sales_order_source ,ctlaf.tax_exempt_flag trx_line_tax_exempt_flag ,ctlaf.tax_exempt_number trx_line_tax_exempt_number ,ctlaf.tax_exempt_reason_code trx_line_tax_exmpt_reason_code ,ctlaf.tax_precedence trx_line_tax_precedence ,ctlaf.tax_rate trx_line_tax_rate ,ctlaf.translated_description trx_line_translated_desc ,ctlaf.unit_selling_price trx_line_unit_selling_price ,ctlaf.unit_standard_price trx_line_unit_standard_price ,ctlaf.uom_code trx_line_uom_code ,ctlgdf.account_class trx_line_dist_account_class ,ctlgdf.amount trx_line_dist_amt ,ctlgdf.attribute1 trx_line_dist_attr1 ,ctlgdf.attribute10 trx_line_dist_attr10 ,ctlgdf.attribute11 trx_line_dist_attr11 ,ctlgdf.attribute12 trx_line_dist_attr12 ,ctlgdf.attribute13 trx_line_dist_attr13 ,ctlgdf.attribute14 trx_line_dist_attr14 ,ctlgdf.attribute15 trx_line_dist_attr15 ,ctlgdf.attribute2 trx_line_dist_attr2 ,ctlgdf.attribute3 trx_line_dist_attr3 ,ctlgdf.attribute4 trx_line_dist_attr4 ,ctlgdf.attribute5 trx_line_dist_attr5 ,ctlgdf.attribute6 trx_line_dist_attr6 ,ctlgdf.attribute7 trx_line_dist_attr7 ,ctlgdf.attribute8 trx_line_dist_attr8 ,ctlgdf.attribute9 trx_line_dist_attr9 ,ctlgdf.attribute_category trx_line_dist_attr_cat ,ctlgdf.concatenated_segments trx_line_dist_ccseg ,ctlgdf.code_combination_id trx_line_dist_ccid ,ctlgdf.collected_tax_ccid trx_line_dist_col_tax_ccid ,ctlgdf.collected_tax_concat_seg trx_line_dist_col_tax_ccseg ,ctlgdf.comments trx_line_dist_comments ,l.cust_trx_line_gl_dist_id trx_line_dist_id ,ctlgdf.gl_date trx_line_dist_gl_date ,ctlgdf.percent trx_line_dist_percent ,ctlgdf.rev_adj_class_temp trx_line_dist_rev_adj_class ,ctlgdf.ussgl_transaction_code trx_line_dist_ussgl_code ,ctlgdf.ussgl_transaction_code_context trx_line_dist_ussgl_code_ct ,l.paired_ccid trx_line_dist_paired_ccid ,mlabf.global_attribute1 memo_line_global_attr1 ,mlabf.global_attribute2 memo_line_global_attr2 ,mlabf.global_attribute3 memo_line_global_attr3 ,mlabf.global_attribute4 memo_line_global_attr4 ,mlabf.global_attribute5 memo_line_global_attr5 ,mlabf.global_attribute6 memo_line_global_attr6 ,mlabf.global_attribute7 memo_line_global_attr7 ,mlabf.global_attribute_category memo_line_global_attr_cat ,mlabf.gl_id_rev memo_line_rev_ccid ,mlabf.line_type memo_line_type ,mlabf.memo_line_id memo_line_id ,mlabf.tax_code memo_line_tax_code ,mlabf.unit_std_price memo_line_unit_std_price ,mlabf.uom_code memo_line_uom_code ,rarlf.deferred_revenue_flag acct_rule_deferred_rev_flag ,rarlf.description acct_rule_description ,rarlf.frequency acct_rule_frequency ,rarlf.name acct_rule_name ,rarlf.occurrences acct_rule_occurrences ,rarlf.rule_id acct_rule_id ,rarlf.type acct_rule_type ,'RA_CUST_TRX_LINE_GL_DIST_ALL' trx_distribution_type ,l.event_id event_id ,l.line_number line_number ,l.language language ,l.ledger_id ledger_id ,pctlgd.account_class TRX_LINE_DIST_PAIRED_ACC_CLASS ,ctlaf.tax_line_id trx_tax_line_id FROM ar_xla_lines_extract l ,ra_cust_trx_line_gl_dist_all ctlgdf ,ra_customer_trx_lines_all ctlaf ,ar_memo_lines_all_b mlabf ,ra_rules rarlf ,ra_cust_trx_line_gl_dist_all pctlgd WHERE ctlgdf.cust_trx_line_gl_dist_id = l.cust_trx_line_gl_dist_id AND ctlaf.customer_trx_line_id(+) = l.customer_trx_line_id AND l.level_flag = 'L' AND ctlaf.memo_line_id = mlabf.memo_line_id (+) AND ctlaf.org_id = mlabf.org_id (+) AND ctlaf.accounting_rule_id = rarlf.rule_id (+) AND l.paire_dist_id = pctlgd.cust_trx_line_gl_dist_id(+)

View Text - HTML Formatted

SELECT /*+ INDEX(L AR_XLA_LINES_EXTRACT_N1) */ CTLAF.ACCOUNTING_RULE_DURATION TRX_LINE_ACCT_RULE_DURATION
, CTLAF.AMOUNT_INCLUDES_TAX_FLAG TRX_LINE_AMT_INCLUDES_TAX_FLAG
, CTLAF.ATTRIBUTE1 TRX_LINE_ATTR1
, CTLAF.ATTRIBUTE10 TRX_LINE_ATTR10
, CTLAF.ATTRIBUTE11 TRX_LINE_ATTR11
, CTLAF.ATTRIBUTE12 TRX_LINE_ATTR12
, CTLAF.ATTRIBUTE13 TRX_LINE_ATTR13
, CTLAF.ATTRIBUTE14 TRX_LINE_ATTR14
, CTLAF.ATTRIBUTE15 TRX_LINE_ATTR15
, CTLAF.ATTRIBUTE2 TRX_LINE_ATTR2
, CTLAF.ATTRIBUTE3 TRX_LINE_ATTR3
, CTLAF.ATTRIBUTE4 TRX_LINE_ATTR4
, CTLAF.ATTRIBUTE5 TRX_LINE_ATTR5
, CTLAF.ATTRIBUTE6 TRX_LINE_ATTR6
, CTLAF.ATTRIBUTE7 TRX_LINE_ATTR7
, CTLAF.ATTRIBUTE8 TRX_LINE_ATTR8
, CTLAF.ATTRIBUTE9 TRX_LINE_ATTR9
, CTLAF.ATTRIBUTE_CATEGORY TRX_LINE_ATTR_CAT
, CTLAF.CUSTOMER_TRX_LINE_ID TRX_LINE_CUSTOMER_TRX_LINE_ID
, CTLAF.DESCRIPTION TRX_LINE_DESCRIPTION
, CTLAF.GLOBAL_ATTRIBUTE1 TRX_LINE_GLOBAL_ATTR1
, CTLAF.GLOBAL_ATTRIBUTE10 TRX_LINE_GLOBAL_ATTR10
, CTLAF.GLOBAL_ATTRIBUTE11 TRX_LINE_GLOBAL_ATTR11
, CTLAF.GLOBAL_ATTRIBUTE12 TRX_LINE_GLOBAL_ATTR12
, CTLAF.GLOBAL_ATTRIBUTE13 TRX_LINE_GLOBAL_ATTR13
, CTLAF.GLOBAL_ATTRIBUTE14 TRX_LINE_GLOBAL_ATTR14
, CTLAF.GLOBAL_ATTRIBUTE15 TRX_LINE_GLOBAL_ATTR15
, CTLAF.GLOBAL_ATTRIBUTE16 TRX_LINE_GLOBAL_ATTR16
, CTLAF.GLOBAL_ATTRIBUTE17 TRX_LINE_GLOBAL_ATTR17
, CTLAF.GLOBAL_ATTRIBUTE18 TRX_LINE_GLOBAL_ATTR18
, CTLAF.GLOBAL_ATTRIBUTE19 TRX_LINE_GLOBAL_ATTR19
, CTLAF.GLOBAL_ATTRIBUTE2 TRX_LINE_GLOBAL_ATTR2
, CTLAF.GLOBAL_ATTRIBUTE20 TRX_LINE_GLOBAL_ATTR20
, CTLAF.GLOBAL_ATTRIBUTE3 TRX_LINE_GLOBAL_ATTR3
, CTLAF.GLOBAL_ATTRIBUTE4 TRX_LINE_GLOBAL_ATTR4
, CTLAF.GLOBAL_ATTRIBUTE5 TRX_LINE_GLOBAL_ATTR5
, CTLAF.GLOBAL_ATTRIBUTE6 TRX_LINE_GLOBAL_ATTR6
, CTLAF.GLOBAL_ATTRIBUTE7 TRX_LINE_GLOBAL_ATTR7
, CTLAF.GLOBAL_ATTRIBUTE8 TRX_LINE_GLOBAL_ATTR8
, CTLAF.GLOBAL_ATTRIBUTE9 TRX_LINE_GLOBAL_ATTR9
, CTLAF.GLOBAL_ATTRIBUTE_CATEGORY TRX_LINE_GLOBAL_ATTR_CAT
, CTLAF.GROSS_UNIT_SELLING_PRICE TRX_LINE_GROSS_UNIT_SELL_PRICE
, CTLAF.INTERFACE_LINE_ATTRIBUTE1 TRX_LINE_INTERFACE_LINE_ATTR1
, CTLAF.INTERFACE_LINE_ATTRIBUTE10 TRX_LINE_INTERFACE_LINE_ATTR10
, CTLAF.INTERFACE_LINE_ATTRIBUTE11 TRX_LINE_INTERFACE_LINE_ATTR11
, CTLAF.INTERFACE_LINE_ATTRIBUTE12 TRX_LINE_INTERFACE_LINE_ATTR12
, CTLAF.INTERFACE_LINE_ATTRIBUTE13 TRX_LINE_INTERFACE_LINE_ATTR13
, CTLAF.INTERFACE_LINE_ATTRIBUTE14 TRX_LINE_INTERFACE_LINE_ATTR14
, CTLAF.INTERFACE_LINE_ATTRIBUTE15 TRX_LINE_INTERFACE_LINE_ATTR15
, CTLAF.INTERFACE_LINE_ATTRIBUTE2 TRX_LINE_INTERFACE_LINE_ATTR2
, CTLAF.INTERFACE_LINE_ATTRIBUTE3 TRX_LINE_INTERFACE_LINE_ATTR3
, CTLAF.INTERFACE_LINE_ATTRIBUTE4 TRX_LINE_INTERFACE_LINE_ATTR4
, CTLAF.INTERFACE_LINE_ATTRIBUTE5 TRX_LINE_INTERFACE_LINE_ATTR5
, CTLAF.INTERFACE_LINE_ATTRIBUTE6 TRX_LINE_INTERFACE_LINE_ATTR6
, CTLAF.INTERFACE_LINE_ATTRIBUTE7 TRX_LINE_INTERFACE_LINE_ATTR7
, CTLAF.INTERFACE_LINE_ATTRIBUTE8 TRX_LINE_INTERFACE_LINE_ATTR8
, CTLAF.INTERFACE_LINE_ATTRIBUTE9 TRX_LINE_INTERFACE_LINE_ATTR9
, CTLAF.INTERFACE_LINE_CONTEXT TRX_LINE_INTERFACE_LINE_CT
, CTLAF.ITEM_CONTEXT TRX_LINE_ITEM_CT
, CTLAF.LINE_NUMBER TRX_LINE_LINE_NUMBER
, CTLAF.LINE_TYPE TRX_LINE_LINE_TYPE
, CTLAF.QUANTITY_CREDITED TRX_LINE_QUANTITY_CREDITED
, CTLAF.QUANTITY_INVOICED TRX_LINE_QUANTITY_INVOICED
, CTLAF.QUANTITY_ORDERED TRX_LINE_QUANTITY_ORDERED
, CTLAF.REASON_CODE TRX_LINE_REASON_CODE
, CTLAF.RULE_START_DATE TRX_LINE_RULE_START_DATE
, CTLAF.SALES_ORDER TRX_LINE_SALES_ORDER
, CTLAF.SALES_ORDER_DATE TRX_LINE_SALES_ORDER_DATE
, CTLAF.SALES_ORDER_LINE TRX_LINE_SALES_ORDER_LINE
, CTLAF.SALES_ORDER_SOURCE TRX_LINE_SALES_ORDER_SOURCE
, CTLAF.TAX_EXEMPT_FLAG TRX_LINE_TAX_EXEMPT_FLAG
, CTLAF.TAX_EXEMPT_NUMBER TRX_LINE_TAX_EXEMPT_NUMBER
, CTLAF.TAX_EXEMPT_REASON_CODE TRX_LINE_TAX_EXMPT_REASON_CODE
, CTLAF.TAX_PRECEDENCE TRX_LINE_TAX_PRECEDENCE
, CTLAF.TAX_RATE TRX_LINE_TAX_RATE
, CTLAF.TRANSLATED_DESCRIPTION TRX_LINE_TRANSLATED_DESC
, CTLAF.UNIT_SELLING_PRICE TRX_LINE_UNIT_SELLING_PRICE
, CTLAF.UNIT_STANDARD_PRICE TRX_LINE_UNIT_STANDARD_PRICE
, CTLAF.UOM_CODE TRX_LINE_UOM_CODE
, CTLGDF.ACCOUNT_CLASS TRX_LINE_DIST_ACCOUNT_CLASS
, CTLGDF.AMOUNT TRX_LINE_DIST_AMT
, CTLGDF.ATTRIBUTE1 TRX_LINE_DIST_ATTR1
, CTLGDF.ATTRIBUTE10 TRX_LINE_DIST_ATTR10
, CTLGDF.ATTRIBUTE11 TRX_LINE_DIST_ATTR11
, CTLGDF.ATTRIBUTE12 TRX_LINE_DIST_ATTR12
, CTLGDF.ATTRIBUTE13 TRX_LINE_DIST_ATTR13
, CTLGDF.ATTRIBUTE14 TRX_LINE_DIST_ATTR14
, CTLGDF.ATTRIBUTE15 TRX_LINE_DIST_ATTR15
, CTLGDF.ATTRIBUTE2 TRX_LINE_DIST_ATTR2
, CTLGDF.ATTRIBUTE3 TRX_LINE_DIST_ATTR3
, CTLGDF.ATTRIBUTE4 TRX_LINE_DIST_ATTR4
, CTLGDF.ATTRIBUTE5 TRX_LINE_DIST_ATTR5
, CTLGDF.ATTRIBUTE6 TRX_LINE_DIST_ATTR6
, CTLGDF.ATTRIBUTE7 TRX_LINE_DIST_ATTR7
, CTLGDF.ATTRIBUTE8 TRX_LINE_DIST_ATTR8
, CTLGDF.ATTRIBUTE9 TRX_LINE_DIST_ATTR9
, CTLGDF.ATTRIBUTE_CATEGORY TRX_LINE_DIST_ATTR_CAT
, CTLGDF.CONCATENATED_SEGMENTS TRX_LINE_DIST_CCSEG
, CTLGDF.CODE_COMBINATION_ID TRX_LINE_DIST_CCID
, CTLGDF.COLLECTED_TAX_CCID TRX_LINE_DIST_COL_TAX_CCID
, CTLGDF.COLLECTED_TAX_CONCAT_SEG TRX_LINE_DIST_COL_TAX_CCSEG
, CTLGDF.COMMENTS TRX_LINE_DIST_COMMENTS
, L.CUST_TRX_LINE_GL_DIST_ID TRX_LINE_DIST_ID
, CTLGDF.GL_DATE TRX_LINE_DIST_GL_DATE
, CTLGDF.PERCENT TRX_LINE_DIST_PERCENT
, CTLGDF.REV_ADJ_CLASS_TEMP TRX_LINE_DIST_REV_ADJ_CLASS
, CTLGDF.USSGL_TRANSACTION_CODE TRX_LINE_DIST_USSGL_CODE
, CTLGDF.USSGL_TRANSACTION_CODE_CONTEXT TRX_LINE_DIST_USSGL_CODE_CT
, L.PAIRED_CCID TRX_LINE_DIST_PAIRED_CCID
, MLABF.GLOBAL_ATTRIBUTE1 MEMO_LINE_GLOBAL_ATTR1
, MLABF.GLOBAL_ATTRIBUTE2 MEMO_LINE_GLOBAL_ATTR2
, MLABF.GLOBAL_ATTRIBUTE3 MEMO_LINE_GLOBAL_ATTR3
, MLABF.GLOBAL_ATTRIBUTE4 MEMO_LINE_GLOBAL_ATTR4
, MLABF.GLOBAL_ATTRIBUTE5 MEMO_LINE_GLOBAL_ATTR5
, MLABF.GLOBAL_ATTRIBUTE6 MEMO_LINE_GLOBAL_ATTR6
, MLABF.GLOBAL_ATTRIBUTE7 MEMO_LINE_GLOBAL_ATTR7
, MLABF.GLOBAL_ATTRIBUTE_CATEGORY MEMO_LINE_GLOBAL_ATTR_CAT
, MLABF.GL_ID_REV MEMO_LINE_REV_CCID
, MLABF.LINE_TYPE MEMO_LINE_TYPE
, MLABF.MEMO_LINE_ID MEMO_LINE_ID
, MLABF.TAX_CODE MEMO_LINE_TAX_CODE
, MLABF.UNIT_STD_PRICE MEMO_LINE_UNIT_STD_PRICE
, MLABF.UOM_CODE MEMO_LINE_UOM_CODE
, RARLF.DEFERRED_REVENUE_FLAG ACCT_RULE_DEFERRED_REV_FLAG
, RARLF.DESCRIPTION ACCT_RULE_DESCRIPTION
, RARLF.FREQUENCY ACCT_RULE_FREQUENCY
, RARLF.NAME ACCT_RULE_NAME
, RARLF.OCCURRENCES ACCT_RULE_OCCURRENCES
, RARLF.RULE_ID ACCT_RULE_ID
, RARLF.TYPE ACCT_RULE_TYPE
, 'RA_CUST_TRX_LINE_GL_DIST_ALL' TRX_DISTRIBUTION_TYPE
, L.EVENT_ID EVENT_ID
, L.LINE_NUMBER LINE_NUMBER
, L.LANGUAGE LANGUAGE
, L.LEDGER_ID LEDGER_ID
, PCTLGD.ACCOUNT_CLASS TRX_LINE_DIST_PAIRED_ACC_CLASS
, CTLAF.TAX_LINE_ID TRX_TAX_LINE_ID
FROM AR_XLA_LINES_EXTRACT L
, RA_CUST_TRX_LINE_GL_DIST_ALL CTLGDF
, RA_CUSTOMER_TRX_LINES_ALL CTLAF
, AR_MEMO_LINES_ALL_B MLABF
, RA_RULES RARLF
, RA_CUST_TRX_LINE_GL_DIST_ALL PCTLGD
WHERE CTLGDF.CUST_TRX_LINE_GL_DIST_ID = L.CUST_TRX_LINE_GL_DIST_ID
AND CTLAF.CUSTOMER_TRX_LINE_ID(+) = L.CUSTOMER_TRX_LINE_ID
AND L.LEVEL_FLAG = 'L'
AND CTLAF.MEMO_LINE_ID = MLABF.MEMO_LINE_ID (+)
AND CTLAF.ORG_ID = MLABF.ORG_ID (+)
AND CTLAF.ACCOUNTING_RULE_ID = RARLF.RULE_ID (+)
AND L.PAIRE_DIST_ID = PCTLGD.CUST_TRX_LINE_GL_DIST_ID(+)