VIEW: APPS.AR_CM_LINES_L_V

Source

View Text - Preformatted

SELECT /*+INDEX(l ar_xla_lines_extract_n1)*/ 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 ,decode(ctlaf.line_type, 'LINE', ctlaf.interface_line_attribute14 ,decode(ctlaf2.interface_line_context, 'OKL_CONTRACTS', nvl(ctlaf.interface_line_attribute14, ctlaf2.interface_line_attribute14), 'OKL_INVESTOR', nvl(ctlaf.interface_line_attribute14, ctlaf2.interface_line_attribute14), 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 ,SUBSTRB(ctlaf.translated_description,1,240) 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 ,ctlgdf.ussgl_transaction_code cm_line_dist_ussgl_code ,ctlgdf.ussgl_transaction_code_context cm_line_dist_ussgl_code_ct ,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 ,mlabf.gl_id_rev cm_memo_line_rev_ccid ,mlabf.line_type cm_memo_line_type ,mlabf.memo_line_id cm_memo_line_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 ,l.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 FROM ar_xla_lines_extract l ,ra_cust_trx_line_gl_dist_all ctlgdf ,ra_customer_trx_lines_all ctlaf ,ra_customer_trx_lines_all ctlaf2 ,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(+) AND l.posting_entity = 'CTLGD' AND l.event_id = ctlgdf.event_id AND ctlaf.customer_trx_id = ctlaf2.customer_trx_id(+) AND ctlaf.link_to_cust_trx_line_id = ctlaf2.customer_trx_line_id(+)

View Text - HTML Formatted

SELECT /*+INDEX(L AR_XLA_LINES_EXTRACT_N1)*/ 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
, DECODE(CTLAF.LINE_TYPE
, 'LINE'
, CTLAF.INTERFACE_LINE_ATTRIBUTE14
, DECODE(CTLAF2.INTERFACE_LINE_CONTEXT
, 'OKL_CONTRACTS'
, NVL(CTLAF.INTERFACE_LINE_ATTRIBUTE14
, CTLAF2.INTERFACE_LINE_ATTRIBUTE14)
, 'OKL_INVESTOR'
, NVL(CTLAF.INTERFACE_LINE_ATTRIBUTE14
, CTLAF2.INTERFACE_LINE_ATTRIBUTE14)
, 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
, SUBSTRB(CTLAF.TRANSLATED_DESCRIPTION
, 1
, 240) 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
, CTLGDF.USSGL_TRANSACTION_CODE CM_LINE_DIST_USSGL_CODE
, CTLGDF.USSGL_TRANSACTION_CODE_CONTEXT CM_LINE_DIST_USSGL_CODE_CT
, 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
, MLABF.GL_ID_REV CM_MEMO_LINE_REV_CCID
, MLABF.LINE_TYPE CM_MEMO_LINE_TYPE
, MLABF.MEMO_LINE_ID CM_MEMO_LINE_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
, L.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
FROM AR_XLA_LINES_EXTRACT L
, RA_CUST_TRX_LINE_GL_DIST_ALL CTLGDF
, RA_CUSTOMER_TRX_LINES_ALL CTLAF
, RA_CUSTOMER_TRX_LINES_ALL CTLAF2
, 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(+)
AND L.POSTING_ENTITY = 'CTLGD'
AND L.EVENT_ID = CTLGDF.EVENT_ID
AND CTLAF.CUSTOMER_TRX_ID = CTLAF2.CUSTOMER_TRX_ID(+)
AND CTLAF.LINK_TO_CUST_TRX_LINE_ID = CTLAF2.CUSTOMER_TRX_LINE_ID(+)