VIEW: APPS.AR_MISC_CASH_DIST_L_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'