View: AR_CM_LINES_L_V

Product:	AR - Receivables
Description:	credit memo line extract
Implementation/DBA Data:	APPS.AR_CM_LINES_L_V

View Text

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
, 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
, 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
, 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
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(+)
AND L.POSTING_ENTITY = 'CTLGD'
AND L.EVENT_ID = CTLGDF.EVENT_ID

Columns