View: AR_CUST_TRX_LINES_L_V

Product:	AR - Receivables
Description:	transaction line extract
Implementation/DBA Data:	APPS.AR_CUST_TRX_LINES_L_V

View Text

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
, 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)) 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
, SUBSTRB(CTLAF.TRANSLATED_DESCRIPTION
, 1
, 240) 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
, CTLAF.TAX_CLASSIFICATION_CODE TRX_LINE_TAX_CLASS_CODE
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 CTLAF.CUSTOMER_TRX_ID = CTLAF2.CUSTOMER_TRX_ID(+)
AND CTLAF.LINK_TO_CUST_TRX_LINE_ID = CTLAF2.CUSTOMER_TRX_LINE_ID(+) UNION SELECT /*+ INDEX(L AR_XLA_LINES_EXTRACT_N1) */ NULL TRX_LINE_ACCT_RULE_DURATION
, NULL TRX_LINE_AMT_INCLUDES_TAX_FLAG
, ADJ.ATTRIBUTE1 TRX_LINE_ATTR1
, ADJ.ATTRIBUTE10 TRX_LINE_ATTR10
, ADJ.ATTRIBUTE11 TRX_LINE_ATTR11
, ADJ.ATTRIBUTE12 TRX_LINE_ATTR12
, ADJ.ATTRIBUTE13 TRX_LINE_ATTR13
, ADJ.ATTRIBUTE14 TRX_LINE_ATTR14
, ADJ.ATTRIBUTE15 TRX_LINE_ATTR15
, ADJ.ATTRIBUTE2 TRX_LINE_ATTR2
, ADJ.ATTRIBUTE3 TRX_LINE_ATTR3
, ADJ.ATTRIBUTE4 TRX_LINE_ATTR4
, ADJ.ATTRIBUTE5 TRX_LINE_ATTR5
, ADJ.ATTRIBUTE6 TRX_LINE_ATTR6
, ADJ.ATTRIBUTE7 TRX_LINE_ATTR7
, ADJ.ATTRIBUTE8 TRX_LINE_ATTR8
, ADJ.ATTRIBUTE9 TRX_LINE_ATTR9
, ADJ.ATTRIBUTE_CATEGORY TRX_LINE_ATTR_CAT
, ADJ.CUSTOMER_TRX_LINE_ID TRX_LINE_CUSTOMER_TRX_LINE_ID
, NULL TRX_LINE_DESCRIPTION
, ADJ.GLOBAL_ATTRIBUTE1 TRX_LINE_GLOBAL_ATTR1
, ADJ.GLOBAL_ATTRIBUTE10 TRX_LINE_GLOBAL_ATTR10
, ADJ.GLOBAL_ATTRIBUTE11 TRX_LINE_GLOBAL_ATTR11
, ADJ.GLOBAL_ATTRIBUTE12 TRX_LINE_GLOBAL_ATTR12
, ADJ.GLOBAL_ATTRIBUTE13 TRX_LINE_GLOBAL_ATTR13
, ADJ.GLOBAL_ATTRIBUTE14 TRX_LINE_GLOBAL_ATTR14
, ADJ.GLOBAL_ATTRIBUTE15 TRX_LINE_GLOBAL_ATTR15
, ADJ.GLOBAL_ATTRIBUTE16 TRX_LINE_GLOBAL_ATTR16
, ADJ.GLOBAL_ATTRIBUTE17 TRX_LINE_GLOBAL_ATTR17
, ADJ.GLOBAL_ATTRIBUTE18 TRX_LINE_GLOBAL_ATTR18
, ADJ.GLOBAL_ATTRIBUTE19 TRX_LINE_GLOBAL_ATTR19
, ADJ.GLOBAL_ATTRIBUTE2 TRX_LINE_GLOBAL_ATTR2
, ADJ.GLOBAL_ATTRIBUTE20 TRX_LINE_GLOBAL_ATTR20
, ADJ.GLOBAL_ATTRIBUTE3 TRX_LINE_GLOBAL_ATTR3
, ADJ.GLOBAL_ATTRIBUTE4 TRX_LINE_GLOBAL_ATTR4
, ADJ.GLOBAL_ATTRIBUTE5 TRX_LINE_GLOBAL_ATTR5
, ADJ.GLOBAL_ATTRIBUTE6 TRX_LINE_GLOBAL_ATTR6
, ADJ.GLOBAL_ATTRIBUTE7 TRX_LINE_GLOBAL_ATTR7
, ADJ.GLOBAL_ATTRIBUTE8 TRX_LINE_GLOBAL_ATTR8
, ADJ.GLOBAL_ATTRIBUTE9 TRX_LINE_GLOBAL_ATTR9
, ADJ.GLOBAL_ATTRIBUTE_CATEGORY TRX_LINE_GLOBAL_ATTR_CAT
, NULL TRX_LINE_GROSS_UNIT_SELL_PRICE
, NULL TRX_LINE_INTERFACE_LINE_ATTR1
, NULL TRX_LINE_INTERFACE_LINE_ATTR10
, NULL TRX_LINE_INTERFACE_LINE_ATTR11
, NULL TRX_LINE_INTERFACE_LINE_ATTR12
, NULL TRX_LINE_INTERFACE_LINE_ATTR13
, NULL TRX_LINE_INTERFACE_LINE_ATTR14
, NULL TRX_LINE_INTERFACE_LINE_ATTR15
, NULL TRX_LINE_INTERFACE_LINE_ATTR2
, NULL TRX_LINE_INTERFACE_LINE_ATTR3
, NULL TRX_LINE_INTERFACE_LINE_ATTR4
, NULL TRX_LINE_INTERFACE_LINE_ATTR5
, NULL TRX_LINE_INTERFACE_LINE_ATTR6
, NULL TRX_LINE_INTERFACE_LINE_ATTR7
, NULL TRX_LINE_INTERFACE_LINE_ATTR8
, NULL TRX_LINE_INTERFACE_LINE_ATTR9
, NULL TRX_LINE_INTERFACE_LINE_CT
, NULL TRX_LINE_ITEM_CT
, NULL TRX_LINE_LINE_NUMBER
, 'TAX' TRX_LINE_LINE_TYPE
, NULL TRX_LINE_QUANTITY_CREDITED
, NULL TRX_LINE_QUANTITY_INVOICED
, NULL TRX_LINE_QUANTITY_ORDERED
, ADJ.REASON_CODE TRX_LINE_REASON_CODE
, NULL TRX_LINE_RULE_START_DATE
, NULL TRX_LINE_SALES_ORDER
, NULL TRX_LINE_SALES_ORDER_DATE
, NULL TRX_LINE_SALES_ORDER_LINE
, NULL TRX_LINE_SALES_ORDER_SOURCE
, NULL TRX_LINE_TAX_EXEMPT_FLAG
, NULL TRX_LINE_TAX_EXEMPT_NUMBER
, NULL TRX_LINE_TAX_EXMPT_REASON_CODE
, NULL TRX_LINE_TAX_PRECEDENCE
, NULL TRX_LINE_TAX_RATE
, NULL TRX_LINE_TRANSLATED_DESC
, NULL TRX_LINE_UNIT_SELLING_PRICE
, NULL TRX_LINE_UNIT_STANDARD_PRICE
, NULL TRX_LINE_UOM_CODE
, 'TAX' TRX_LINE_DIST_ACCOUNT_CLASS
, ADJ.AMOUNT TRX_LINE_DIST_AMT
, NULL TRX_LINE_DIST_ATTR1
, NULL TRX_LINE_DIST_ATTR10
, NULL TRX_LINE_DIST_ATTR11
, NULL TRX_LINE_DIST_ATTR12
, NULL TRX_LINE_DIST_ATTR13
, NULL TRX_LINE_DIST_ATTR14
, NULL TRX_LINE_DIST_ATTR15
, NULL TRX_LINE_DIST_ATTR2
, NULL TRX_LINE_DIST_ATTR3
, NULL TRX_LINE_DIST_ATTR4
, NULL TRX_LINE_DIST_ATTR5
, NULL TRX_LINE_DIST_ATTR6
, NULL TRX_LINE_DIST_ATTR7
, NULL TRX_LINE_DIST_ATTR8
, NULL TRX_LINE_DIST_ATTR9
, NULL TRX_LINE_DIST_ATTR_CAT
, NULL TRX_LINE_DIST_CCSEG
, ARD_ADJ.CODE_COMBINATION_ID TRX_LINE_DIST_CCID
, NULL TRX_LINE_DIST_COL_TAX_CCID
, NULL TRX_LINE_DIST_COL_TAX_CCSEG
, NULL TRX_LINE_DIST_COMMENTS
, L.CUST_TRX_LINE_GL_DIST_ID TRX_LINE_DIST_ID
, ADJ.GL_DATE TRX_LINE_DIST_GL_DATE
, NULL TRX_LINE_DIST_PERCENT
, NULL TRX_LINE_DIST_REV_ADJ_CLASS
, ADJ.USSGL_TRANSACTION_CODE TRX_LINE_DIST_USSGL_CODE
, ADJ.USSGL_TRANSACTION_CODE_CONTEXT TRX_LINE_DIST_USSGL_CODE_CT
, L.PAIRED_CCID TRX_LINE_DIST_PAIRED_CCID
, NULL MEMO_LINE_GLOBAL_ATTR1
, NULL MEMO_LINE_GLOBAL_ATTR2
, NULL MEMO_LINE_GLOBAL_ATTR3
, NULL MEMO_LINE_GLOBAL_ATTR4
, NULL MEMO_LINE_GLOBAL_ATTR5
, NULL MEMO_LINE_GLOBAL_ATTR6
, NULL MEMO_LINE_GLOBAL_ATTR7
, NULL MEMO_LINE_GLOBAL_ATTR_CAT
, NULL MEMO_LINE_REV_CCID
, NULL MEMO_LINE_TYPE
, NULL MEMO_LINE_ID
, NULL MEMO_LINE_TAX_CODE
, NULL MEMO_LINE_UNIT_STD_PRICE
, NULL MEMO_LINE_UOM_CODE
, NULL ACCT_RULE_DEFERRED_REV_FLAG
, NULL ACCT_RULE_DESCRIPTION
, NULL ACCT_RULE_FREQUENCY
, NULL ACCT_RULE_NAME
, NULL ACCT_RULE_OCCURRENCES
, NULL ACCT_RULE_ID
, NULL ACCT_RULE_TYPE
, 'AR_DISTRIBUTIONS_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
, NULL TRX_TAX_LINE_ID
, NULL TRX_LINE_TAX_CLASS_CODE
FROM AR_XLA_LINES_EXTRACT L
, AR_DISTRIBUTIONS_ALL ARD
, AR_DISTRIBUTIONS_ALL ARD_ADJ
, AR_ADJUSTMENTS_ALL ADJ
, RA_CUST_TRX_LINE_GL_DIST_ALL PCTLGD
WHERE L.POSTING_ENTITY = 'APP'
AND L.LEVEL_FLAG = 'L'
AND L.SOURCE_ID = ARD.SOURCE_ID
AND L.SOURCE_TABLE = ARD.SOURCE_TABLE
AND L.LINE_ID = ARD.LINE_ID
AND ARD.REF_CUSTOMER_TRX_LINE_ID = -8
AND ARD.REF_CUST_TRX_LINE_GL_DIST_ID = -8 /* APPLICATION AGAINST BOUNDARY TAX ADJUSTMENT LINE*/
AND ARD.REF_LINE_ID = ARD_ADJ.LINE_ID
AND ARD_ADJ.SOURCE_TABLE = 'ADJ'
AND ARD_ADJ.SOURCE_ID = ADJ.ADJUSTMENT_ID
AND L.PAIRE_DIST_ID = PCTLGD.CUST_TRX_LINE_GL_DIST_ID(+)

Columns