View: AR_CM_APP_DIST_LINES_L_V

Product:	AR - Receivables
Description:	This view is used to fetch interface line attributes data for CM applications.
Implementation/DBA Data:	APPS.AR_CM_APP_DIST_LINES_L_V

View Text

SELECT /*+INDEX(L AR_XLA_LINES_EXTRACT_N1)*/ CTLAF.CUSTOMER_TRX_ID CM_APP_CUSTOMER_TRX_ID
, CTLAF.CUSTOMER_TRX_LINE_ID CM_APP_CUSTOMER_TRX_LINE_ID
, CTLAF.LINE_NUMBER CM_APP_LINE_NUMBER
, CTLAF.LINE_TYPE CM_APP_LINE_TYPE
, CTLAF.INTERFACE_LINE_CONTEXT CM_APP_INTERFACE_LINE_CT
, CTLAF.INTERFACE_LINE_ATTRIBUTE1 CM_APP_INTERFACE_LINE_ATTR1
, CTLAF.INTERFACE_LINE_ATTRIBUTE2 CM_APP_INTERFACE_LINE_ATTR2
, CTLAF.INTERFACE_LINE_ATTRIBUTE3 CM_APP_INTERFACE_LINE_ATTR3
, CTLAF.INTERFACE_LINE_ATTRIBUTE4 CM_APP_INTERFACE_LINE_ATTR4
, CTLAF.INTERFACE_LINE_ATTRIBUTE5 CM_APP_INTERFACE_LINE_ATTR5
, CTLAF.INTERFACE_LINE_ATTRIBUTE6 CM_APP_INTERFACE_LINE_ATTR6
, CTLAF.INTERFACE_LINE_ATTRIBUTE7 CM_APP_INTERFACE_LINE_ATTR7
, CTLAF.INTERFACE_LINE_ATTRIBUTE8 CM_APP_INTERFACE_LINE_ATTR8
, CTLAF.INTERFACE_LINE_ATTRIBUTE9 CM_APP_INTERFACE_LINE_ATTR9
, CTLAF.INTERFACE_LINE_ATTRIBUTE10 CM_APP_INTERFACE_LINE_ATTR10
, CTLAF.INTERFACE_LINE_ATTRIBUTE11 CM_APP_INTERFACE_LINE_ATTR11
, CTLAF.INTERFACE_LINE_ATTRIBUTE12 CM_APP_INTERFACE_LINE_ATTR12
, CTLAF.INTERFACE_LINE_ATTRIBUTE13 CM_APP_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_APP_INTERFACE_LINE_ATTR14
, CTLAF.INTERFACE_LINE_ATTRIBUTE15 CM_APP_INTERFACE_LINE_ATTR15
, L.LINE_ID CM_APP_EXTRACT_LINE_ID
, L.PAIRED_CCID CM_APP_EXTRACT_PAIRED_CCID
, L.EVENT_ID EVENT_ID
, L.LINE_NUMBER LINE_NUMBER
, L.LANGUAGE LANGUAGE
, L.LEDGER_ID LEDGER_ID
, L.FROM_TO_FLAG FROM_TO_FLAG
, 'AR_DISTRIBUTIONS_ALL' CM_APP_DISTRIBUTION_TYPE
, ARDIST.LINE_ID CM_APP_DIST_LINE_ID
, ARDIST.SOURCE_ID CM_APP_DIST_SOURCE_ID
, ARDIST.SOURCE_TABLE CM_APP_DIST_SOURCE_TABLE
, ARDIST.SOURCE_TYPE CM_APP_DIST_SOURCE_TYPE
, ARDIST.CODE_COMBINATION_ID CM_APP_DIST_CCID
FROM AR_XLA_LINES_EXTRACT L
, AR_DISTRIBUTIONS_ALL ARDIST
, RA_CUSTOMER_TRX_LINES_ALL CTLAF
, RA_CUSTOMER_TRX_LINES_ALL CTLAF2
WHERE ARDIST.LINE_ID = L.LINE_ID
AND ARDIST.REF_CUSTOMER_TRX_LINE_ID = CTLAF.CUSTOMER_TRX_LINE_ID
AND CTLAF.CUSTOMER_TRX_LINE_ID(+) = L.CUSTOMER_TRX_LINE_ID
AND L.LEVEL_FLAG = 'L'
AND L.POSTING_ENTITY = 'APP'
AND L.EVENT_TYPE_CODE IN ('CM_CREATE'
, 'CM_UPDATE')
AND L.MFAR_ADDITIONAL_ENTRY = 'N'
AND CTLAF.CUSTOMER_TRX_ID = CTLAF2.CUSTOMER_TRX_ID(+)
AND CTLAF.LINK_TO_CUST_TRX_LINE_ID = CTLAF2.CUSTOMER_TRX_LINE_ID(+)

Columns