AR_CM_LINES_L

Details

Schema: FUSION
Object owner: AR
Object type: VIEW

Columns

Name
CM_LINE_ACCT_RULE_DURATION CM_LINE_AMT_INCLUDES_TAX_FLAG CM_LINE_ATTR1 CM_LINE_ATTR10 CM_LINE_ATTR11 CM_LINE_ATTR12 CM_LINE_ATTR13 CM_LINE_ATTR14 CM_LINE_ATTR15 CM_LINE_ATTR2 CM_LINE_ATTR3 CM_LINE_ATTR4 CM_LINE_ATTR5 CM_LINE_ATTR6 CM_LINE_ATTR7 CM_LINE_ATTR8 CM_LINE_ATTR9 CM_LINE_ATTR_CAT CM_LINE_CUSTOMER_TRX_LINE_ID CM_LINE_DESCRIPTION CM_LINE_GLOBAL_ATTR1 CM_LINE_GLOBAL_ATTR10 CM_LINE_GLOBAL_ATTR11 CM_LINE_GLOBAL_ATTR12 CM_LINE_GLOBAL_ATTR13 CM_LINE_GLOBAL_ATTR14 CM_LINE_GLOBAL_ATTR15 CM_LINE_GLOBAL_ATTR16 CM_LINE_GLOBAL_ATTR17 CM_LINE_GLOBAL_ATTR18 CM_LINE_GLOBAL_ATTR19 CM_LINE_GLOBAL_ATTR2 CM_LINE_GLOBAL_ATTR20 CM_LINE_GLOBAL_ATTR3 CM_LINE_GLOBAL_ATTR4 CM_LINE_GLOBAL_ATTR5 CM_LINE_GLOBAL_ATTR6 CM_LINE_GLOBAL_ATTR7 CM_LINE_GLOBAL_ATTR8 CM_LINE_GLOBAL_ATTR9 CM_LINE_GLOBAL_ATTR_CAT CM_LINE_GROSS_UNIT_SELL_PRICE CM_LINE_INTERFACE_LINE_ATTR1 CM_LINE_INTERFACE_LINE_ATTR10 CM_LINE_INTERFACE_LINE_ATTR11 CM_LINE_INTERFACE_LINE_ATTR12 CM_LINE_INTERFACE_LINE_ATTR13 CM_LINE_INTERFACE_LINE_ATTR14 CM_LINE_INTERFACE_LINE_ATTR15 CM_LINE_INTERFACE_LINE_ATTR2 CM_LINE_INTERFACE_LINE_ATTR3 CM_LINE_INTERFACE_LINE_ATTR4 CM_LINE_INTERFACE_LINE_ATTR5 CM_LINE_INTERFACE_LINE_ATTR6 CM_LINE_INTERFACE_LINE_ATTR7 CM_LINE_INTERFACE_LINE_ATTR8 CM_LINE_INTERFACE_LINE_ATTR9 CM_LINE_INTERFACE_LINE_CT CM_LINE_ITEM_CT CM_LINE_LINE_NUMBER CM_LINE_LINE_TYPE CM_LINE_QUANTITY_CREDITED CM_LINE_QUANTITY_INVOICED CM_LINE_QUANTITY_ORDERED CM_LINE_REASON_CODE CM_LINE_RULE_START_DATE CM_LINE_SALES_ORDER CM_LINE_SALES_ORDER_DATE CM_LINE_SALES_ORDER_LINE CM_LINE_SALES_ORDER_SOURCE CM_LINE_TAX_EXEMPT_FLAG CM_LINE_TAX_EXEMPT_NUMBER CM_LINE_TAX_EXMPT_REASON_CODE CM_LINE_TAX_PRECEDENCE CM_LINE_TAX_RATE CM_LINE_TRANSLATED_DESC CM_LINE_UNIT_SELLING_PRICE CM_LINE_UNIT_STANDARD_PRICE CM_LINE_UOM_CODE CM_LINE_DIST_ACCOUNT_CLASS CM_LINE_DIST_AMT CM_LINE_DIST_ATTR1 CM_LINE_DIST_ATTR10 CM_LINE_DIST_ATTR11 CM_LINE_DIST_ATTR12 CM_LINE_DIST_ATTR13 CM_LINE_DIST_ATTR14 CM_LINE_DIST_ATTR15 CM_LINE_DIST_ATTR2 CM_LINE_DIST_ATTR3 CM_LINE_DIST_ATTR4 CM_LINE_DIST_ATTR5 CM_LINE_DIST_ATTR6 CM_LINE_DIST_ATTR7 CM_LINE_DIST_ATTR8 CM_LINE_DIST_ATTR9 CM_LINE_DIST_ATTR_CAT CM_LINE_DIST_CCSEG CM_LINE_DIST_CCID CM_LINE_DIST_COL_TAX_CCID CM_LINE_DIST_COL_TAX_CCSEG CM_LINE_DIST_COMMENTS CM_LINE_DIST_ID CM_LINE_DIST_GL_DATE CM_LINE_DIST_PERCENT CM_LINE_DIST_REV_ADJ_CLASS CM_LINE_DIST_PAIRED_CCID CM_MEMO_LINE_GLOBAL_ATTR1 CM_MEMO_LINE_GLOBAL_ATTR2 CM_MEMO_LINE_GLOBAL_ATTR3 CM_MEMO_LINE_GLOBAL_ATTR4 CM_MEMO_LINE_GLOBAL_ATTR5 CM_MEMO_LINE_GLOBAL_ATTR6 CM_MEMO_LINE_GLOBAL_ATTR7 CM_MEMO_LINE_GLOBAL_ATTR_CAT CM_MEMO_LINE_REV_CCID CM_MEMO_LINE_TYPE CM_MEMO_LINE_SEQ_ID CM_MEMO_LINE_TAX_CODE CM_MEMO_LINE_UNIT_STD_PRICE CM_MEMO_LINE_UOM_CODE CM_ACCT_RULE_DEFERRED_REV_FLAG CM_ACCT_RULE_DESCRIPTION CM_ACCT_RULE_FREQUENCY CM_ACCT_RULE_NAME CM_ACCT_RULE_OCCURRENCES CM_ACCT_RULE_ID CM_ACCT_RULE_TYPE CM_DISTRIBUTION_TYPE EVENT_ID LINE_NUMBER LANGUAGE LEDGER_ID CM_LINE_DIST_PAIRED_ACC_CLASS CM_TAX_LINE_ID CUSTOMER_TRX_ID

Name

CM_LINE_ACCT_RULE_DURATION

CM_LINE_AMT_INCLUDES_TAX_FLAG

CM_LINE_ATTR1

CM_LINE_ATTR10

CM_LINE_ATTR11

CM_LINE_ATTR12

CM_LINE_ATTR13

CM_LINE_ATTR14

CM_LINE_ATTR15

CM_LINE_ATTR2

CM_LINE_ATTR3

CM_LINE_ATTR4

CM_LINE_ATTR5

CM_LINE_ATTR6

CM_LINE_ATTR7

CM_LINE_ATTR8

CM_LINE_ATTR9

CM_LINE_ATTR_CAT

CM_LINE_CUSTOMER_TRX_LINE_ID

CM_LINE_DESCRIPTION

CM_LINE_GLOBAL_ATTR1

CM_LINE_GLOBAL_ATTR10

CM_LINE_GLOBAL_ATTR11

CM_LINE_GLOBAL_ATTR12

CM_LINE_GLOBAL_ATTR13

CM_LINE_GLOBAL_ATTR14

CM_LINE_GLOBAL_ATTR15

CM_LINE_GLOBAL_ATTR16

CM_LINE_GLOBAL_ATTR17

CM_LINE_GLOBAL_ATTR18

CM_LINE_GLOBAL_ATTR19

CM_LINE_GLOBAL_ATTR2

CM_LINE_GLOBAL_ATTR20

CM_LINE_GLOBAL_ATTR3

CM_LINE_GLOBAL_ATTR4

CM_LINE_GLOBAL_ATTR5

CM_LINE_GLOBAL_ATTR6

CM_LINE_GLOBAL_ATTR7

CM_LINE_GLOBAL_ATTR8

CM_LINE_GLOBAL_ATTR9

CM_LINE_GLOBAL_ATTR_CAT

CM_LINE_GROSS_UNIT_SELL_PRICE

CM_LINE_INTERFACE_LINE_ATTR1

CM_LINE_INTERFACE_LINE_ATTR10

CM_LINE_INTERFACE_LINE_ATTR11

CM_LINE_INTERFACE_LINE_ATTR12

CM_LINE_INTERFACE_LINE_ATTR13

CM_LINE_INTERFACE_LINE_ATTR14

CM_LINE_INTERFACE_LINE_ATTR15

CM_LINE_INTERFACE_LINE_ATTR2

CM_LINE_INTERFACE_LINE_ATTR3

CM_LINE_INTERFACE_LINE_ATTR4

CM_LINE_INTERFACE_LINE_ATTR5

CM_LINE_INTERFACE_LINE_ATTR6

CM_LINE_INTERFACE_LINE_ATTR7

CM_LINE_INTERFACE_LINE_ATTR8

CM_LINE_INTERFACE_LINE_ATTR9

CM_LINE_INTERFACE_LINE_CT

CM_LINE_ITEM_CT

CM_LINE_LINE_NUMBER

CM_LINE_LINE_TYPE

CM_LINE_QUANTITY_CREDITED

CM_LINE_QUANTITY_INVOICED

CM_LINE_QUANTITY_ORDERED

CM_LINE_REASON_CODE

CM_LINE_RULE_START_DATE

CM_LINE_SALES_ORDER

CM_LINE_SALES_ORDER_DATE

CM_LINE_SALES_ORDER_LINE

CM_LINE_SALES_ORDER_SOURCE

CM_LINE_TAX_EXEMPT_FLAG

CM_LINE_TAX_EXEMPT_NUMBER

CM_LINE_TAX_EXMPT_REASON_CODE

CM_LINE_TAX_PRECEDENCE

CM_LINE_TAX_RATE

CM_LINE_TRANSLATED_DESC

CM_LINE_UNIT_SELLING_PRICE

CM_LINE_UNIT_STANDARD_PRICE

CM_LINE_UOM_CODE

CM_LINE_DIST_ACCOUNT_CLASS

CM_LINE_DIST_AMT

CM_LINE_DIST_ATTR1

CM_LINE_DIST_ATTR10

CM_LINE_DIST_ATTR11

CM_LINE_DIST_ATTR12

CM_LINE_DIST_ATTR13

CM_LINE_DIST_ATTR14

CM_LINE_DIST_ATTR15

CM_LINE_DIST_ATTR2

CM_LINE_DIST_ATTR3

CM_LINE_DIST_ATTR4

CM_LINE_DIST_ATTR5

CM_LINE_DIST_ATTR6

CM_LINE_DIST_ATTR7

CM_LINE_DIST_ATTR8

CM_LINE_DIST_ATTR9

CM_LINE_DIST_ATTR_CAT

CM_LINE_DIST_CCSEG

CM_LINE_DIST_CCID

CM_LINE_DIST_COL_TAX_CCID

CM_LINE_DIST_COL_TAX_CCSEG

CM_LINE_DIST_COMMENTS

CM_LINE_DIST_ID

CM_LINE_DIST_GL_DATE

CM_LINE_DIST_PERCENT

CM_LINE_DIST_REV_ADJ_CLASS

CM_LINE_DIST_PAIRED_CCID

CM_MEMO_LINE_GLOBAL_ATTR1

CM_MEMO_LINE_GLOBAL_ATTR2

CM_MEMO_LINE_GLOBAL_ATTR3

CM_MEMO_LINE_GLOBAL_ATTR4

CM_MEMO_LINE_GLOBAL_ATTR5

CM_MEMO_LINE_GLOBAL_ATTR6

CM_MEMO_LINE_GLOBAL_ATTR7

CM_MEMO_LINE_GLOBAL_ATTR_CAT

CM_MEMO_LINE_REV_CCID

CM_MEMO_LINE_TYPE

CM_MEMO_LINE_SEQ_ID

CM_MEMO_LINE_TAX_CODE

CM_MEMO_LINE_UNIT_STD_PRICE

CM_MEMO_LINE_UOM_CODE

CM_ACCT_RULE_DEFERRED_REV_FLAG

CM_ACCT_RULE_DESCRIPTION

CM_ACCT_RULE_FREQUENCY

CM_ACCT_RULE_NAME

CM_ACCT_RULE_OCCURRENCES

CM_ACCT_RULE_ID

CM_ACCT_RULE_TYPE

CM_DISTRIBUTION_TYPE

EVENT_ID

LINE_NUMBER

LANGUAGE

LEDGER_ID

CM_LINE_DIST_PAIRED_ACC_CLASS

CM_TAX_LINE_ID

CUSTOMER_TRX_ID

Query

SQL_Statement
SELECT ctlaf.accounting_rule_duration cm_line_acct_rule_duration , ctlaf.amount_includes_tax_flag cm_line_amt_includes_tax_flag , ctlaf.attribute1 cm_line_attr1 , ctlaf.attribute10 cm_line_attr10 , ctlaf.attribute11 cm_line_attr11 , ctlaf.attribute12 cm_line_attr12 , ctlaf.attribute13 cm_line_attr13 , ctlaf.attribute14 cm_line_attr14 , ctlaf.attribute15 cm_line_attr15 , ctlaf.attribute2 cm_line_attr2 , ctlaf.attribute3 cm_line_attr3 , ctlaf.attribute4 cm_line_attr4 , ctlaf.attribute5 cm_line_attr5 , ctlaf.attribute6 cm_line_attr6 , ctlaf.attribute7 cm_line_attr7 , ctlaf.attribute8 cm_line_attr8 , ctlaf.attribute9 cm_line_attr9 , ctlaf.attribute_category cm_line_attr_cat , ctlaf.customer_trx_line_id cm_line_customer_trx_line_id , ctlaf.description cm_line_description , ctlaf.global_attribute1 cm_line_global_attr1 , ctlaf.global_attribute10 cm_line_global_attr10 , ctlaf.global_attribute11 cm_line_global_attr11 , ctlaf.global_attribute12 cm_line_global_attr12 , ctlaf.global_attribute13 cm_line_global_attr13 , ctlaf.global_attribute14 cm_line_global_attr14 , ctlaf.global_attribute15 cm_line_global_attr15 , ctlaf.global_attribute16 cm_line_global_attr16 , ctlaf.global_attribute17 cm_line_global_attr17 , ctlaf.global_attribute18 cm_line_global_attr18 , ctlaf.global_attribute19 cm_line_global_attr19 , ctlaf.global_attribute2 cm_line_global_attr2 , ctlaf.global_attribute20 cm_line_global_attr20 , ctlaf.global_attribute3 cm_line_global_attr3 , ctlaf.global_attribute4 cm_line_global_attr4 , ctlaf.global_attribute5 cm_line_global_attr5 , ctlaf.global_attribute6 cm_line_global_attr6 , ctlaf.global_attribute7 cm_line_global_attr7 , ctlaf.global_attribute8 cm_line_global_attr8 , ctlaf.global_attribute9 cm_line_global_attr9 , ctlaf.global_attribute_category cm_line_global_attr_cat , ctlaf.gross_unit_selling_price cm_line_gross_unit_sell_price , ctlaf.interface_line_attribute1 cm_line_interface_line_attr1 , ctlaf.interface_line_attribute10 cm_line_interface_line_attr10 , ctlaf.interface_line_attribute11 cm_line_interface_line_attr11 , ctlaf.interface_line_attribute12 cm_line_interface_line_attr12 , ctlaf.interface_line_attribute13 cm_line_interface_line_attr13 , ctlaf.interface_line_attribute14 cm_line_interface_line_attr14 , ctlaf.interface_line_attribute15 cm_line_interface_line_attr15 , ctlaf.interface_line_attribute2 cm_line_interface_line_attr2 , ctlaf.interface_line_attribute3 cm_line_interface_line_attr3 , ctlaf.interface_line_attribute4 cm_line_interface_line_attr4 , ctlaf.interface_line_attribute5 cm_line_interface_line_attr5 , ctlaf.interface_line_attribute6 cm_line_interface_line_attr6 , ctlaf.interface_line_attribute7 cm_line_interface_line_attr7 , ctlaf.interface_line_attribute8 cm_line_interface_line_attr8 , ctlaf.interface_line_attribute9 cm_line_interface_line_attr9 , ctlaf.interface_line_context cm_line_interface_line_ct , ctlaf.item_context cm_line_item_ct , ctlaf.line_number cm_line_line_number , ctlaf.line_type cm_line_line_type , ctlaf.quantity_credited cm_line_quantity_credited , ctlaf.quantity_invoiced cm_line_quantity_invoiced , ctlaf.quantity_ordered cm_line_quantity_ordered , ctlaf.reason_code cm_line_reason_code , ctlaf.rule_start_date cm_line_rule_start_date , ctlaf.sales_order cm_line_sales_order , ctlaf.sales_order_date cm_line_sales_order_date , ctlaf.sales_order_line cm_line_sales_order_line , ctlaf.sales_order_source cm_line_sales_order_source , ctlaf.tax_exempt_flag cm_line_tax_exempt_flag , ctlaf.tax_exempt_number cm_line_tax_exempt_number , ctlaf.tax_exempt_reason_code cm_line_tax_exmpt_reason_code , ctlaf.tax_precedence cm_line_tax_precedence , ctlaf.tax_rate cm_line_tax_rate , ctlaf.translated_description cm_line_translated_desc , ctlaf.unit_selling_price cm_line_unit_selling_price , ctlaf.unit_standard_price cm_line_unit_standard_price , ctlaf.uom_code cm_line_uom_code , ctlgdf.account_class cm_line_dist_account_class , ctlgdf.amount cm_line_dist_amt , ctlgdf.attribute1 cm_line_dist_attr1 , ctlgdf.attribute10 cm_line_dist_attr10 , ctlgdf.attribute11 cm_line_dist_attr11 , ctlgdf.attribute12 cm_line_dist_attr12 , ctlgdf.attribute13 cm_line_dist_attr13 , ctlgdf.attribute14 cm_line_dist_attr14 , ctlgdf.attribute15 cm_line_dist_attr15 , ctlgdf.attribute2 cm_line_dist_attr2 , ctlgdf.attribute3 cm_line_dist_attr3 , ctlgdf.attribute4 cm_line_dist_attr4 , ctlgdf.attribute5 cm_line_dist_attr5 , ctlgdf.attribute6 cm_line_dist_attr6 , ctlgdf.attribute7 cm_line_dist_attr7 , ctlgdf.attribute8 cm_line_dist_attr8 , ctlgdf.attribute9 cm_line_dist_attr9 , ctlgdf.attribute_category cm_line_dist_attr_cat , ctlgdf.concatenated_segments cm_line_dist_ccseg , ctlgdf.code_combination_id cm_line_dist_ccid , ctlgdf.collected_tax_ccid cm_line_dist_col_tax_ccid , ctlgdf.collected_tax_concat_seg cm_line_dist_col_tax_ccseg , ctlgdf.comments cm_line_dist_comments , l.cust_trx_line_gl_dist_id cm_line_dist_id , ctlgdf.gl_date cm_line_dist_gl_date , ctlgdf.percent cm_line_dist_percent , ctlgdf.rev_adj_class_temp cm_line_dist_rev_adj_class , l.paired_ccid cm_line_dist_paired_ccid , mlabf.global_attribute1 cm_memo_line_global_attr1 , mlabf.global_attribute2 cm_memo_line_global_attr2 , mlabf.global_attribute3 cm_memo_line_global_attr3 , mlabf.global_attribute4 cm_memo_line_global_attr4 , mlabf.global_attribute5 cm_memo_line_global_attr5 , mlabf.global_attribute6 cm_memo_line_global_attr6 , mlabf.global_attribute7 cm_memo_line_global_attr7 , mlabf.global_attribute_category cm_memo_line_global_attr_cat , refacc.REV_CCID cm_memo_line_rev_ccid , mlabf.line_type cm_memo_line_type , mlabf.memo_line_seq_id cm_memo_line_seq_id , mlabf.tax_code cm_memo_line_tax_code , mlabf.unit_std_price cm_memo_line_unit_std_price , mlabf.uom_code cm_memo_line_uom_code , rarlf.deferred_revenue_flag cm_acct_rule_deferred_rev_flag , rarlf.description cm_acct_rule_description , rarlf.frequency cm_acct_rule_frequency , rarlf.name cm_acct_rule_name , rarlf.occurrences cm_acct_rule_occurrences , rarlf.rule_id cm_acct_rule_id , rarlf.type cm_acct_rule_type , 'RA_CUST_TRX_LINE_GL_DIST_ALL' cm_distribution_type , ctlgdf.event_id event_id , l.line_number line_number , l.language language , l.ledger_id ledger_id , pctlgd.account_class CM_LINE_DIST_PAIRED_ACC_CLASS , ctlaf.tax_line_id cm_tax_line_id, ctlgdf.customer_trx_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, AR_REF_ACCOUNTS_ALL refacc 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 refacc.source_ref_account_id(+)= ctlaf.memo_line_seq_id AND refacc.SOURCE_REF_TABLE(+)= 'AR_MEMO_LINES_ALL_B' AND refacc.bu_id(+) = ctlaf.org_id AND l.level_flag = 'L' AND ctlaf.memo_line_seq_id = mlabf.memo_line_seq_id (+) AND ctlaf.accounting_rule_id = rarlf.rule_id (+) AND l.paire_dist_id = pctlgd.cust_trx_line_gl_dist_id(+) AND l.posting_entity = 'CTLGD' AND l.event_id = ctlgdf.event_id UNION ALL SELECT NULL cm_line_acct_rule_duration , NULL cm_line_amt_includes_tax_flag , NULL cm_line_attr1 , NULL cm_line_attr10 , NULL cm_line_attr11 , NULL cm_line_attr12 , NULL cm_line_attr13 , NULL cm_line_attr14 , NULL cm_line_attr15 , NULL cm_line_attr2 , NULL cm_line_attr3 , NULL cm_line_attr4 , NULL cm_line_attr5 , NULL cm_line_attr6 , NULL cm_line_attr7 , NULL cm_line_attr8 , NULL cm_line_attr9 , NULL cm_line_attr_cat , NULL cm_line_customer_trx_line_id , NULL cm_line_description , NULL cm_line_global_attr1 , NULL cm_line_global_attr10 , NULL cm_line_global_attr11 , NULL cm_line_global_attr12 , NULL cm_line_global_attr13 , NULL cm_line_global_attr14 , NULL cm_line_global_attr15 , NULL cm_line_global_attr16 , NULL cm_line_global_attr17 , NULL cm_line_global_attr18 , NULL cm_line_global_attr19 , NULL cm_line_global_attr2 , NULL cm_line_global_attr20 , NULL cm_line_global_attr3 , NULL cm_line_global_attr4 , NULL cm_line_global_attr5 , NULL cm_line_global_attr6 , NULL cm_line_global_attr7 , NULL cm_line_global_attr8 , NULL cm_line_global_attr9 , NULL cm_line_global_attr_cat , NULL cm_line_gross_unit_sell_price , NULL cm_line_interface_line_attr1 , NULL cm_line_interface_line_attr10 , NULL cm_line_interface_line_attr11 , NULL cm_line_interface_line_attr12 , NULL cm_line_interface_line_attr13 , NULL cm_line_interface_line_attr14 , NULL cm_line_interface_line_attr15 , NULL cm_line_interface_line_attr2 , NULL cm_line_interface_line_attr3 , NULL cm_line_interface_line_attr4 , NULL cm_line_interface_line_attr5 , NULL cm_line_interface_line_attr6 , NULL cm_line_interface_line_attr7 , NULL cm_line_interface_line_attr8 , NULL cm_line_interface_line_attr9 , NULL cm_line_interface_line_ct , NULL cm_line_item_ct , NULL cm_line_line_number , NULL cm_line_line_type , NULL cm_line_quantity_credited , NULL cm_line_quantity_invoiced , NULL cm_line_quantity_ordered , NULL cm_line_reason_code , NULL cm_line_rule_start_date , NULL cm_line_sales_order , NULL cm_line_sales_order_date , NULL cm_line_sales_order_line , NULL cm_line_sales_order_source , NULL cm_line_tax_exempt_flag , NULL cm_line_tax_exempt_number , NULL cm_line_tax_exmpt_reason_code , NULL cm_line_tax_precedence , NULL cm_line_tax_rate , NULL cm_line_translated_desc , NULL cm_line_unit_selling_price , NULL cm_line_unit_standard_price , NULL cm_line_uom_code , NULL cm_line_dist_account_class , NULL cm_line_dist_amt , NULL cm_line_dist_attr1 , NULL cm_line_dist_attr10 , NULL cm_line_dist_attr11 , NULL cm_line_dist_attr12 , NULL cm_line_dist_attr13 , NULL cm_line_dist_attr14 , NULL cm_line_dist_attr15 , NULL cm_line_dist_attr2 , NULL cm_line_dist_attr3 , NULL cm_line_dist_attr4 , NULL cm_line_dist_attr5 , NULL cm_line_dist_attr6 , NULL cm_line_dist_attr7 , NULL cm_line_dist_attr8 , NULL cm_line_dist_attr9 , NULL cm_line_dist_attr_cat , NULL cm_line_dist_ccseg , NULL cm_line_dist_ccid , NULL cm_line_dist_col_tax_ccid , NULL cm_line_dist_col_tax_ccseg , NULL cm_line_dist_comments , NULL cm_line_dist_id , NULL cm_line_dist_gl_date , NULL cm_line_dist_percent , NULL cm_line_dist_rev_adj_class , NULL cm_line_dist_paired_ccid , NULL cm_memo_line_global_attr1 , NULL cm_memo_line_global_attr2 , NULL cm_memo_line_global_attr3 , NULL cm_memo_line_global_attr4 , NULL cm_memo_line_global_attr5 , NULL cm_memo_line_global_attr6 , NULL cm_memo_line_global_attr7 , NULL cm_memo_line_global_attr_cat , NULL cm_memo_line_rev_ccid , NULL cm_memo_line_type , NULL cm_memo_line_seq_id , NULL cm_memo_line_tax_code , NULL cm_memo_line_unit_std_price , NULL cm_memo_line_uom_code , NULL cm_acct_rule_deferred_rev_flag , NULL cm_acct_rule_description , NULL cm_acct_rule_frequency , NULL cm_acct_rule_name , NULL cm_acct_rule_occurrences , NULL cm_acct_rule_id , NULL cm_acct_rule_type , 'AR_DISTRIBUTIONS_ALL' cm_distribution_type , l.event_id event_id , l.line_number line_number , l.language language , l.ledger_id ledger_id , NULL CM_LINE_DIST_PAIRED_ACC_CLASS , NULL cm_tax_line_id, l.customer_trx_id FROM ar_xla_lines_extract l , ra_customer_trx_all ct WHERE l.posting_entity = 'APP' AND l.level_flag = 'L' AND l.customer_trx_id IS NOT NULL AND l.from_to_flag = 'F' AND l.event_type_code IN ('CM_CREATE','CM_UPDATE') AND ct.customer_trx_id = l.customer_trx_id

SQL_Statement

SELECT

ctlaf.accounting_rule_duration cm_line_acct_rule_duration ,

ctlaf.amount_includes_tax_flag cm_line_amt_includes_tax_flag ,

ctlaf.attribute1 cm_line_attr1 ,

ctlaf.attribute10 cm_line_attr10 ,

ctlaf.attribute11 cm_line_attr11 ,

ctlaf.attribute12 cm_line_attr12 ,

ctlaf.attribute13 cm_line_attr13 ,

ctlaf.attribute14 cm_line_attr14 ,

ctlaf.attribute15 cm_line_attr15 ,

ctlaf.attribute2 cm_line_attr2 ,

ctlaf.attribute3 cm_line_attr3 ,

ctlaf.attribute4 cm_line_attr4 ,

ctlaf.attribute5 cm_line_attr5 ,

ctlaf.attribute6 cm_line_attr6 ,

ctlaf.attribute7 cm_line_attr7 ,

ctlaf.attribute8 cm_line_attr8 ,

ctlaf.attribute9 cm_line_attr9 ,

ctlaf.attribute_category cm_line_attr_cat ,

ctlaf.customer_trx_line_id cm_line_customer_trx_line_id ,

ctlaf.description cm_line_description ,

ctlaf.global_attribute1 cm_line_global_attr1 ,

ctlaf.global_attribute10 cm_line_global_attr10 ,

ctlaf.global_attribute11 cm_line_global_attr11 ,

ctlaf.global_attribute12 cm_line_global_attr12 ,

ctlaf.global_attribute13 cm_line_global_attr13 ,

ctlaf.global_attribute14 cm_line_global_attr14 ,

ctlaf.global_attribute15 cm_line_global_attr15 ,

ctlaf.global_attribute16 cm_line_global_attr16 ,

ctlaf.global_attribute17 cm_line_global_attr17 ,

ctlaf.global_attribute18 cm_line_global_attr18 ,

ctlaf.global_attribute19 cm_line_global_attr19 ,

ctlaf.global_attribute2 cm_line_global_attr2 ,

ctlaf.global_attribute20 cm_line_global_attr20 ,

ctlaf.global_attribute3 cm_line_global_attr3 ,

ctlaf.global_attribute4 cm_line_global_attr4 ,

ctlaf.global_attribute5 cm_line_global_attr5 ,

ctlaf.global_attribute6 cm_line_global_attr6 ,

ctlaf.global_attribute7 cm_line_global_attr7 ,

ctlaf.global_attribute8 cm_line_global_attr8 ,

ctlaf.global_attribute9 cm_line_global_attr9 ,

ctlaf.global_attribute_category cm_line_global_attr_cat ,

ctlaf.gross_unit_selling_price cm_line_gross_unit_sell_price ,

ctlaf.interface_line_attribute1 cm_line_interface_line_attr1 ,

ctlaf.interface_line_attribute10 cm_line_interface_line_attr10 ,

ctlaf.interface_line_attribute11 cm_line_interface_line_attr11 ,

ctlaf.interface_line_attribute12 cm_line_interface_line_attr12 ,

ctlaf.interface_line_attribute13 cm_line_interface_line_attr13 ,

ctlaf.interface_line_attribute14 cm_line_interface_line_attr14 ,

ctlaf.interface_line_attribute15 cm_line_interface_line_attr15 ,

ctlaf.interface_line_attribute2 cm_line_interface_line_attr2 ,

ctlaf.interface_line_attribute3 cm_line_interface_line_attr3 ,

ctlaf.interface_line_attribute4 cm_line_interface_line_attr4 ,

ctlaf.interface_line_attribute5 cm_line_interface_line_attr5 ,

ctlaf.interface_line_attribute6 cm_line_interface_line_attr6 ,

ctlaf.interface_line_attribute7 cm_line_interface_line_attr7 ,

ctlaf.interface_line_attribute8 cm_line_interface_line_attr8 ,

ctlaf.interface_line_attribute9 cm_line_interface_line_attr9 ,

ctlaf.interface_line_context cm_line_interface_line_ct ,

ctlaf.item_context cm_line_item_ct ,

ctlaf.line_number cm_line_line_number ,

ctlaf.line_type cm_line_line_type ,

ctlaf.quantity_credited cm_line_quantity_credited ,

ctlaf.quantity_invoiced cm_line_quantity_invoiced ,

ctlaf.quantity_ordered cm_line_quantity_ordered ,

ctlaf.reason_code cm_line_reason_code ,

ctlaf.rule_start_date cm_line_rule_start_date ,

ctlaf.sales_order cm_line_sales_order ,

ctlaf.sales_order_date cm_line_sales_order_date ,

ctlaf.sales_order_line cm_line_sales_order_line ,

ctlaf.sales_order_source cm_line_sales_order_source ,

ctlaf.tax_exempt_flag cm_line_tax_exempt_flag ,

ctlaf.tax_exempt_number cm_line_tax_exempt_number ,

ctlaf.tax_exempt_reason_code cm_line_tax_exmpt_reason_code ,

ctlaf.tax_precedence cm_line_tax_precedence ,

ctlaf.tax_rate cm_line_tax_rate ,

ctlaf.translated_description cm_line_translated_desc ,

ctlaf.unit_selling_price cm_line_unit_selling_price ,

ctlaf.unit_standard_price cm_line_unit_standard_price ,

ctlaf.uom_code cm_line_uom_code ,

ctlgdf.account_class cm_line_dist_account_class ,

ctlgdf.amount cm_line_dist_amt ,

ctlgdf.attribute1 cm_line_dist_attr1 ,

ctlgdf.attribute10 cm_line_dist_attr10 ,

ctlgdf.attribute11 cm_line_dist_attr11 ,

ctlgdf.attribute12 cm_line_dist_attr12 ,

ctlgdf.attribute13 cm_line_dist_attr13 ,

ctlgdf.attribute14 cm_line_dist_attr14 ,

ctlgdf.attribute15 cm_line_dist_attr15 ,

ctlgdf.attribute2 cm_line_dist_attr2 ,

ctlgdf.attribute3 cm_line_dist_attr3 ,

ctlgdf.attribute4 cm_line_dist_attr4 ,

ctlgdf.attribute5 cm_line_dist_attr5 ,

ctlgdf.attribute6 cm_line_dist_attr6 ,

ctlgdf.attribute7 cm_line_dist_attr7 ,

ctlgdf.attribute8 cm_line_dist_attr8 ,

ctlgdf.attribute9 cm_line_dist_attr9 ,

ctlgdf.attribute_category cm_line_dist_attr_cat ,

ctlgdf.concatenated_segments cm_line_dist_ccseg ,

ctlgdf.code_combination_id cm_line_dist_ccid ,

ctlgdf.collected_tax_ccid cm_line_dist_col_tax_ccid ,

ctlgdf.collected_tax_concat_seg cm_line_dist_col_tax_ccseg ,

ctlgdf.comments cm_line_dist_comments ,

l.cust_trx_line_gl_dist_id cm_line_dist_id ,

ctlgdf.gl_date cm_line_dist_gl_date ,

ctlgdf.percent cm_line_dist_percent ,

ctlgdf.rev_adj_class_temp cm_line_dist_rev_adj_class ,

l.paired_ccid cm_line_dist_paired_ccid ,

mlabf.global_attribute1 cm_memo_line_global_attr1 ,

mlabf.global_attribute2 cm_memo_line_global_attr2 ,

mlabf.global_attribute3 cm_memo_line_global_attr3 ,

mlabf.global_attribute4 cm_memo_line_global_attr4 ,

mlabf.global_attribute5 cm_memo_line_global_attr5 ,

mlabf.global_attribute6 cm_memo_line_global_attr6 ,

mlabf.global_attribute7 cm_memo_line_global_attr7 ,

mlabf.global_attribute_category cm_memo_line_global_attr_cat ,

refacc.REV_CCID cm_memo_line_rev_ccid ,

mlabf.line_type cm_memo_line_type ,

mlabf.memo_line_seq_id cm_memo_line_seq_id ,

mlabf.tax_code cm_memo_line_tax_code ,

mlabf.unit_std_price cm_memo_line_unit_std_price ,

mlabf.uom_code cm_memo_line_uom_code ,

rarlf.deferred_revenue_flag cm_acct_rule_deferred_rev_flag ,

rarlf.description cm_acct_rule_description ,

rarlf.frequency cm_acct_rule_frequency ,

rarlf.name cm_acct_rule_name ,

rarlf.occurrences cm_acct_rule_occurrences ,

rarlf.rule_id cm_acct_rule_id ,

rarlf.type cm_acct_rule_type ,

'RA_CUST_TRX_LINE_GL_DIST_ALL' cm_distribution_type ,

ctlgdf.event_id event_id ,

l.line_number line_number ,

l.language language ,

l.ledger_id ledger_id ,

pctlgd.account_class CM_LINE_DIST_PAIRED_ACC_CLASS ,

ctlaf.tax_line_id cm_tax_line_id,

ctlgdf.customer_trx_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,

AR_REF_ACCOUNTS_ALL refacc

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 refacc.source_ref_account_id(+)= ctlaf.memo_line_seq_id

AND refacc.SOURCE_REF_TABLE(+)= 'AR_MEMO_LINES_ALL_B'

AND refacc.bu_id(+) = ctlaf.org_id

AND l.level_flag = 'L'

AND ctlaf.memo_line_seq_id = mlabf.memo_line_seq_id (+)

AND ctlaf.accounting_rule_id = rarlf.rule_id (+)

AND l.paire_dist_id = pctlgd.cust_trx_line_gl_dist_id(+)

AND l.posting_entity = 'CTLGD'

AND l.event_id = ctlgdf.event_id

UNION ALL

SELECT

NULL cm_line_acct_rule_duration ,

NULL cm_line_amt_includes_tax_flag ,

NULL cm_line_attr1 ,

NULL cm_line_attr10 ,

NULL cm_line_attr11 ,

NULL cm_line_attr12 ,

NULL cm_line_attr13 ,

NULL cm_line_attr14 ,

NULL cm_line_attr15 ,

NULL cm_line_attr2 ,

NULL cm_line_attr3 ,

NULL cm_line_attr4 ,

NULL cm_line_attr5 ,

NULL cm_line_attr6 ,

NULL cm_line_attr7 ,

NULL cm_line_attr8 ,

NULL cm_line_attr9 ,

NULL cm_line_attr_cat ,

NULL cm_line_customer_trx_line_id ,

NULL cm_line_description ,

NULL cm_line_global_attr1 ,

NULL cm_line_global_attr10 ,

NULL cm_line_global_attr11 ,

NULL cm_line_global_attr12 ,

NULL cm_line_global_attr13 ,

NULL cm_line_global_attr14 ,

NULL cm_line_global_attr15 ,

NULL cm_line_global_attr16 ,

NULL cm_line_global_attr17 ,

NULL cm_line_global_attr18 ,

NULL cm_line_global_attr19 ,

NULL cm_line_global_attr2 ,

NULL cm_line_global_attr20 ,

NULL cm_line_global_attr3 ,

NULL cm_line_global_attr4 ,

NULL cm_line_global_attr5 ,

NULL cm_line_global_attr6 ,

NULL cm_line_global_attr7 ,

NULL cm_line_global_attr8 ,

NULL cm_line_global_attr9 ,

NULL cm_line_global_attr_cat ,

NULL cm_line_gross_unit_sell_price ,

NULL cm_line_interface_line_attr1 ,

NULL cm_line_interface_line_attr10 ,

NULL cm_line_interface_line_attr11 ,

NULL cm_line_interface_line_attr12 ,

NULL cm_line_interface_line_attr13 ,

NULL cm_line_interface_line_attr14 ,

NULL cm_line_interface_line_attr15 ,

NULL cm_line_interface_line_attr2 ,

NULL cm_line_interface_line_attr3 ,

NULL cm_line_interface_line_attr4 ,

NULL cm_line_interface_line_attr5 ,

NULL cm_line_interface_line_attr6 ,

NULL cm_line_interface_line_attr7 ,

NULL cm_line_interface_line_attr8 ,

NULL cm_line_interface_line_attr9 ,

NULL cm_line_interface_line_ct ,

NULL cm_line_item_ct ,

NULL cm_line_line_number ,

NULL cm_line_line_type ,

NULL cm_line_quantity_credited ,

NULL cm_line_quantity_invoiced ,

NULL cm_line_quantity_ordered ,

NULL cm_line_reason_code ,

NULL cm_line_rule_start_date ,

NULL cm_line_sales_order ,

NULL cm_line_sales_order_date ,

NULL cm_line_sales_order_line ,

NULL cm_line_sales_order_source ,

NULL cm_line_tax_exempt_flag ,

NULL cm_line_tax_exempt_number ,

NULL cm_line_tax_exmpt_reason_code ,

NULL cm_line_tax_precedence ,

NULL cm_line_tax_rate ,

NULL cm_line_translated_desc ,

NULL cm_line_unit_selling_price ,

NULL cm_line_unit_standard_price ,

NULL cm_line_uom_code ,

NULL cm_line_dist_account_class ,

NULL cm_line_dist_amt ,

NULL cm_line_dist_attr1 ,

NULL cm_line_dist_attr10 ,

NULL cm_line_dist_attr11 ,

NULL cm_line_dist_attr12 ,

NULL cm_line_dist_attr13 ,

NULL cm_line_dist_attr14 ,

NULL cm_line_dist_attr15 ,

NULL cm_line_dist_attr2 ,

NULL cm_line_dist_attr3 ,

NULL cm_line_dist_attr4 ,

NULL cm_line_dist_attr5 ,

NULL cm_line_dist_attr6 ,

NULL cm_line_dist_attr7 ,

NULL cm_line_dist_attr8 ,

NULL cm_line_dist_attr9 ,

NULL cm_line_dist_attr_cat ,

NULL cm_line_dist_ccseg ,

NULL cm_line_dist_ccid ,

NULL cm_line_dist_col_tax_ccid ,

NULL cm_line_dist_col_tax_ccseg ,

NULL cm_line_dist_comments ,

NULL cm_line_dist_id ,

NULL cm_line_dist_gl_date ,

NULL cm_line_dist_percent ,

NULL cm_line_dist_rev_adj_class ,

NULL cm_line_dist_paired_ccid ,

NULL cm_memo_line_global_attr1 ,

NULL cm_memo_line_global_attr2 ,

NULL cm_memo_line_global_attr3 ,

NULL cm_memo_line_global_attr4 ,

NULL cm_memo_line_global_attr5 ,

NULL cm_memo_line_global_attr6 ,

NULL cm_memo_line_global_attr7 ,

NULL cm_memo_line_global_attr_cat ,

NULL cm_memo_line_rev_ccid ,

NULL cm_memo_line_type ,

NULL cm_memo_line_seq_id ,

NULL cm_memo_line_tax_code ,

NULL cm_memo_line_unit_std_price ,

NULL cm_memo_line_uom_code ,

NULL cm_acct_rule_deferred_rev_flag ,

NULL cm_acct_rule_description ,

NULL cm_acct_rule_frequency ,

NULL cm_acct_rule_name ,

NULL cm_acct_rule_occurrences ,

NULL cm_acct_rule_id ,

NULL cm_acct_rule_type ,

'AR_DISTRIBUTIONS_ALL' cm_distribution_type ,

l.event_id event_id ,

l.line_number line_number ,

l.language language ,

l.ledger_id ledger_id ,

NULL CM_LINE_DIST_PAIRED_ACC_CLASS ,

NULL cm_tax_line_id,

l.customer_trx_id

FROM ar_xla_lines_extract l ,

ra_customer_trx_all ct

WHERE l.posting_entity = 'APP'

AND l.level_flag = 'L'

AND l.customer_trx_id IS NOT NULL

AND l.from_to_flag = 'F'

AND l.event_type_code IN ('CM_CREATE','CM_UPDATE')

AND ct.customer_trx_id = l.customer_trx_id