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 MISC_CASH_GLOBAL_ATTR_CTG MISC_CASH_GLOBAL_ATTR1 MISC_CASH_GLOBAL_ATTR2 MISC_CASH_GLOBAL_ATTR3 MISC_CASH_GLOBAL_ATTR4 MISC_CASH_GLOBAL_ATTR5 MISC_CASH_GLOBAL_ATTR6 MISC_CASH_GLOBAL_ATTR7 MISC_CASH_GLOBAL_ATTR8 MISC_CASH_GLOBAL_ATTR9 MISC_CASH_GLOBAL_ATTR10 MISC_CASH_GLOBAL_ATTR11 MISC_CASH_GLOBAL_ATTR12 MISC_CASH_GLOBAL_ATTR13 MISC_CASH_GLOBAL_ATTR14 MISC_CASH_GLOBAL_ATTR15 MISC_CASH_GLOBAL_ATTR16 MISC_CASH_GLOBAL_ATTR17 MISC_CASH_GLOBAL_ATTR18 MISC_CASH_GLOBAL_ATTR19 MISC_CASH_GLOBAL_ATTR20 MISC_CASH_GLOBAL_ATTR21 MISC_CASH_GLOBAL_ATTR22 MISC_CASH_GLOBAL_ATTR23 MISC_CASH_GLOBAL_ATTR24 MISC_CASH_GLOBAL_ATTR25 MISC_CASH_GLOBAL_ATTR26 MISC_CASH_GLOBAL_ATTR27 MISC_CASH_GLOBAL_ATTR28 MISC_CASH_GLOBAL_ATTR29 MISC_CASH_GLOBAL_ATTR30 MISC_CASH_GLOBAL_ATTRNUM1 MISC_CASH_GLOBAL_ATTRNUM2 MISC_CASH_GLOBAL_ATTRNUM3 MISC_CASH_GLOBAL_ATTRNUM4 MISC_CASH_GLOBAL_ATTRNUM5 MISC_CASH_GLOBAL_ATTRDATE1 MISC_CASH_GLOBAL_ATTRDATE2 MISC_CASH_GLOBAL_ATTRDATE3 MISC_CASH_GLOBAL_ATTRDATE4 MISC_CASH_GLOBAL_ATTRDATE5

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,mcd.global_attribute_category misc_cash_global_attr_ctg, mcd.global_attribute1 misc_cash_global_attr1,mcd.global_attribute2 misc_cash_global_attr2,mcd.global_attribute3 misc_cash_global_attr3,mcd.global_attribute4 misc_cash_global_attr4,mcd.global_attribute5 misc_cash_global_attr5,mcd.global_attribute6 misc_cash_global_attr6,mcd.global_attribute7 misc_cash_global_attr7,mcd.global_attribute8 misc_cash_global_attr8,mcd.global_attribute9 misc_cash_global_attr9,mcd.global_attribute10 misc_cash_global_attr10,mcd.global_attribute11 misc_cash_global_attr11,mcd.global_attribute12 misc_cash_global_attr12,mcd.global_attribute13 misc_cash_global_attr13,mcd.global_attribute14 misc_cash_global_attr14,mcd.global_attribute15 misc_cash_global_attr15,mcd.global_attribute16 misc_cash_global_attr16,mcd.global_attribute17 misc_cash_global_attr17,mcd.global_attribute18 misc_cash_global_attr18,mcd.global_attribute19 misc_cash_global_attr19,mcd.global_attribute20 misc_cash_global_attr20,mcd.global_attribute21 misc_cash_global_attr21,mcd.global_attribute22 misc_cash_global_attr22,mcd.global_attribute23 misc_cash_global_attr23,mcd.global_attribute24 misc_cash_global_attr24,mcd.global_attribute25 misc_cash_global_attr25,mcd.global_attribute26 misc_cash_global_attr26,mcd.global_attribute27 misc_cash_global_attr27,mcd.global_attribute28 misc_cash_global_attr28,mcd.global_attribute29 misc_cash_global_attr29,mcd.global_attribute30 misc_cash_global_attr30,mcd.global_attribute_number1 misc_cash_global_attrnum1,mcd.global_attribute_number2 misc_cash_global_attrnum2,mcd.global_attribute_number3 misc_cash_global_attrnum3,mcd.global_attribute_number4 misc_cash_global_attrnum4,mcd.global_attribute_number5 misc_cash_global_attrnum5,mcd.global_attribute_date1 misc_cash_global_attrdate1,mcd.global_attribute_date2 misc_cash_global_attrdate2,mcd.global_attribute_date3 misc_cash_global_attrdate3,mcd.global_attribute_date4 misc_cash_global_attrdate4,mcd.global_attribute_date5 misc_cash_global_attrdate5 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'