VIEW: APPS.AR_ADJUSTMENTS_H_V

Source

View Text - Preformatted

SELECT /*+INDEX (he ar_xla_lines_extract_n1) dynamic_sampling(0) */ 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 ,SUBSTRB(aa.comments,1,240) adj_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 ,aa.reason_code adj_reason_code ,aa.type 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 FROM ar_adjustments_all aa ,ar_receivables_trx_all rt ,ar_xla_lines_extract he 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'

View Text - HTML Formatted

SELECT /*+INDEX (HE AR_XLA_LINES_EXTRACT_N1) DYNAMIC_SAMPLING(0) */ 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
, SUBSTRB(AA.COMMENTS
, 1
, 240) ADJ_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
, AA.REASON_CODE ADJ_REASON_CODE
, AA.TYPE 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
FROM AR_ADJUSTMENTS_ALL AA
, AR_RECEIVABLES_TRX_ALL RT
, AR_XLA_LINES_EXTRACT HE
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'