View: AR_MISC_CASH_DIST_L_V

Product:	AR - Receivables
Description:	miscellanous cash receipt line distribution extract
Implementation/DBA Data:	APPS.AR_MISC_CASH_DIST_L_V

View Text

SELECT /*+INDEX(L AR_XLA_LINES_EXTRACT_N1)*/ MCD.APPLY_DATE MISC_CASH_APPLY_DATE
, MCD.COMMENTS MISC_CASH_COMMENTS
, MCD.GL_DATE MISC_CASH_GL_DATE
, MCD.REVERSAL_GL_DATE MISC_CASH_REVERSAL_GL_DATE
, MCD.MISC_CASH_DISTRIBUTION_ID MISC_CASH_DIST_ID
, MCD.USSGL_TRANSACTION_CODE MISC_CASH_USSGL_TRX_CODE
, MCD.USSGL_TRANSACTION_CODE_CONTEXT MISC_CASH_USSGL_TRX_CODE_CT
, MCD.ATTRIBUTE1 MISC_CASH_ATTR1
, MCD.ATTRIBUTE2 MISC_CASH_ATTR2
, MCD.ATTRIBUTE3 MISC_CASH_ATTR3
, MCD.ATTRIBUTE4 MISC_CASH_ATTR4
, MCD.ATTRIBUTE5 MISC_CASH_ATTR5
, MCD.ATTRIBUTE6 MISC_CASH_ATTR6
, MCD.ATTRIBUTE7 MISC_CASH_ATTR7
, MCD.ATTRIBUTE8 MISC_CASH_ATTR8
, MCD.ATTRIBUTE9 MISC_CASH_ATTR9
, MCD.ATTRIBUTE10 MISC_CASH_ATTR10
, MCD.ATTRIBUTE11 MISC_CASH_ATTR11
, MCD.ATTRIBUTE12 MISC_CASH_ATTR12
, MCD.ATTRIBUTE13 MISC_CASH_ATTR13
, MCD.ATTRIBUTE14 MISC_CASH_ATTR14
, MCD.ATTRIBUTE15 MISC_CASH_ATTR15
, MCD.ATTRIBUTE_CATEGORY MISC_CASH_ATTR_CAT
, L.EVENT_ID EVENT_ID
, L.LINE_NUMBER LINE_NUMBER
, L.LANGUAGE LANGUAGE
, L.LEDGER_ID LEDGER_ID
FROM AR_MISC_CASH_DISTRIBUTIONS_ALL MCD
, AR_XLA_LINES_EXTRACT L
WHERE MCD.EVENT_ID = L.EVENT_ID
AND L.SOURCE_ID = MCD.MISC_CASH_DISTRIBUTION_ID
AND L.SOURCE_TABLE = 'MCD'
AND L.LEVEL_FLAG = 'L'

Columns