AR_MISC_CASH_DIST_L_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

MISC_CASH_APPLY_DATE MISC_CASH_COMMENTS MISC_CASH_GL_DATE MISC_CASH_REVERSAL_GL_DATE MISC_CASH_DIST_ID MISC_CASH_USSGL_TRX_CODE MISC_CASH_USSGL_TRX_CODE_CT MISC_CASH_ATTR1 MISC_CASH_ATTR2 MISC_CASH_ATTR3 MISC_CASH_ATTR4 MISC_CASH_ATTR5 MISC_CASH_ATTR6 MISC_CASH_ATTR7 MISC_CASH_ATTR8 MISC_CASH_ATTR9 MISC_CASH_ATTR10 MISC_CASH_ATTR11 MISC_CASH_ATTR12 MISC_CASH_ATTR13 MISC_CASH_ATTR14 MISC_CASH_ATTR15 MISC_CASH_ATTR_CAT EVENT_ID LINE_NUMBER LANGUAGE LEDGER_ID

Query

SQL_Statement

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'