AR_ADJUSTMENTS_H_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

ADJ_ID ADJ_NUMBER ADJ_TAX_ACCT_RULE ADJ_ADJ_TYPE ADJ_APPLY_DATE ADJ_ATTR1 ADJ_ATTR10 ADJ_ATTR11 ADJ_ATTR12 ADJ_ATTR13 ADJ_ATTR14 ADJ_ATTR15 ADJ_ATTR2 ADJ_ATTR3 ADJ_ATTR4 ADJ_ATTR5 ADJ_ATTR6 ADJ_ATTR7 ADJ_ATTR8 ADJ_ATTR9 ADJ_ATTR_CAT ADJ_CODE_COMBINATION_ID COMMENTS ADJ_DISTRIB_SET_ID ADJ_DOC_SEQUENCE_ID ADJ_DOC_SEQUENCE_VALUE ADJ_DOC_SEQUENCE_CATEGORY ADJ_GL_DATE ADJ_REASON_CODE ADJ_TYPE ADJ_USSGL_TRX_CODE ADJ_USSGL_TRX_CODE_CT EVENT_ID XLA_PARTY_TYPE ADJ_XLA_APPLIED_TO_APP_ID ADJ_ENTITY_CODE ADJ_GL_ACCOUNT_SOURCE ADJ_TRX_ID

Query

SQL_Statement

SELECT /*+INDEX (he ar_xla_lines_extract_n1) */ aa.adjustment_id adj_id ,aa.adjustment_number adj_number ,aa.adj_tax_acct_rule adj_tax_acct_rule ,aa.adjustment_type adj_adj_type ,aa.apply_date adj_apply_date ,aa.attribute1 adj_attr1 ,aa.attribute10 adj_attr10 ,aa.attribute11 adj_attr11 ,aa.attribute12 adj_attr12 ,aa.attribute13 adj_attr13 ,aa.attribute14 adj_attr14 ,aa.attribute15 adj_attr15 ,aa.attribute2 adj_attr2 ,aa.attribute3 adj_attr3 ,aa.attribute4 adj_attr4 ,aa.attribute5 adj_attr5 ,aa.attribute6 adj_attr6 ,aa.attribute7 adj_attr7 ,aa.attribute8 adj_attr8 ,aa.attribute9 adj_attr9 ,aa.attribute_category adj_attr_cat ,aa.code_combination_id adj_code_combination_id ,aa.comments COMMENTS ,aa.distribution_set_id adj_distrib_set_id ,aa.doc_sequence_id adj_doc_sequence_id ,aa.doc_sequence_value adj_doc_sequence_value ,DECODE(aa.doc_sequence_value, NULL, NULL, rt.name) ADJ_DOC_SEQUENCE_CATEGORY ,aa.gl_date adj_gl_date ,lkp1.meaning adj_reason_code ,lkp2.meaning adj_type ,aa.USSGL_TRANSACTION_CODE adj_ussgl_trx_code ,aa.USSGL_TRANSACTION_CODE_CONTEXT adj_ussgl_trx_code_ct ,he.event_id event_id ,'C' xla_party_type ,222 adj_xla_applied_to_app_id ,'ADJUSTMENTS' adj_entity_code, rt.gl_account_source adj_gl_account_source, aa.customer_trx_id adj_trx_id FROM ar_adjustments_all aa ,ar_receivables_trx_all rt ,ar_xla_lines_extract he,ar_lookups lkp1,ar_lookups lkp2 WHERE aa.event_id = he.event_id AND rt.receivables_trx_id = aa.receivables_trx_id AND aa.org_id = rt.org_id AND he.level_flag = 'H' AND aa.reason_code = lkp1.lookup_code (+) AND aa.type = lkp2.lookup_code AND lkp1.lookup_type (+) = 'ADJUST_REASON' and lkp2.lookup_type = 'ADJUSTMENT_TYPE'