VIEW: APPS.AR_RECEIVABLES_TRX_ED_L_V

Source

View Text - Preformatted

SELECT /*+ INDEX(he AR_XLA_LINES_EXTRACT_N1) */ rtae.asset_tax_code ed_act_asset_tax_code ,rtae.attribute1 ed_act_attr1 ,rtae.attribute10 ed_act_attr10 ,rtae.attribute11 ed_act_attr11 ,rtae.attribute12 ed_act_attr12 ,rtae.attribute13 ed_act_attr13 ,rtae.attribute14 ed_act_attr14 ,rtae.attribute15 ed_act_attr15 ,rtae.attribute2 ed_act_attr2 ,rtae.attribute3 ed_act_attr3 ,rtae.attribute4 ed_act_attr4 ,rtae.attribute5 ed_act_attr5 ,rtae.attribute6 ed_act_attr6 ,rtae.attribute7 ed_act_attr7 ,rtae.attribute8 ed_act_attr8 ,rtae.attribute9 ed_act_attr9 ,rtae.attribute_category ed_act_attr_cat ,rtae.code_combination_id ed_act_code_combination_id ,rtae.default_acctg_distribution_set ed_act_def_acct_distrib_set ,rtae.description ed_act_description ,rtae.gl_account_source ed_act_gl_account_source ,rtae.liability_tax_code ed_act_liability_tax_code ,rtae.name ed_act_name ,rtae.receivables_trx_id ed_act_receivables_trx_id ,rtae.tax_code_source ed_act_tax_code_source ,rtae.tax_recoverable_flag ed_act_tax_recoverable_flag ,rtae.type ed_act_type ,he.event_id event_id ,he.line_number line_number ,he.language language ,he.ledger_id ledger_id FROM ar_receivables_trx_all rtae ,ar_xla_lines_extract he WHERE rtae.receivables_trx_id = he.ed_adj_receivables_trx_id AND he.level_flag = 'L' AND rtae.org_id = he.org_id GROUP BY rtae.asset_tax_code ,rtae.attribute1 ,rtae.attribute10 ,rtae.attribute11 ,rtae.attribute12 ,rtae.attribute13 ,rtae.attribute14 ,rtae.attribute15 ,rtae.attribute2 ,rtae.attribute3 ,rtae.attribute4 ,rtae.attribute5 ,rtae.attribute6 ,rtae.attribute7 ,rtae.attribute8 ,rtae.attribute9 ,rtae.attribute_category ,rtae.code_combination_id ,rtae.default_acctg_distribution_set ,rtae.description ,rtae.gl_account_source ,rtae.liability_tax_code ,rtae.name ,rtae.receivables_trx_id ,rtae.tax_code_source ,rtae.tax_recoverable_flag ,rtae.type ,he.event_id ,he.line_number ,he.language ,he.ledger_id

View Text - HTML Formatted

SELECT /*+ INDEX(HE AR_XLA_LINES_EXTRACT_N1) */ RTAE.ASSET_TAX_CODE ED_ACT_ASSET_TAX_CODE
, RTAE.ATTRIBUTE1 ED_ACT_ATTR1
, RTAE.ATTRIBUTE10 ED_ACT_ATTR10
, RTAE.ATTRIBUTE11 ED_ACT_ATTR11
, RTAE.ATTRIBUTE12 ED_ACT_ATTR12
, RTAE.ATTRIBUTE13 ED_ACT_ATTR13
, RTAE.ATTRIBUTE14 ED_ACT_ATTR14
, RTAE.ATTRIBUTE15 ED_ACT_ATTR15
, RTAE.ATTRIBUTE2 ED_ACT_ATTR2
, RTAE.ATTRIBUTE3 ED_ACT_ATTR3
, RTAE.ATTRIBUTE4 ED_ACT_ATTR4
, RTAE.ATTRIBUTE5 ED_ACT_ATTR5
, RTAE.ATTRIBUTE6 ED_ACT_ATTR6
, RTAE.ATTRIBUTE7 ED_ACT_ATTR7
, RTAE.ATTRIBUTE8 ED_ACT_ATTR8
, RTAE.ATTRIBUTE9 ED_ACT_ATTR9
, RTAE.ATTRIBUTE_CATEGORY ED_ACT_ATTR_CAT
, RTAE.CODE_COMBINATION_ID ED_ACT_CODE_COMBINATION_ID
, RTAE.DEFAULT_ACCTG_DISTRIBUTION_SET ED_ACT_DEF_ACCT_DISTRIB_SET
, RTAE.DESCRIPTION ED_ACT_DESCRIPTION
, RTAE.GL_ACCOUNT_SOURCE ED_ACT_GL_ACCOUNT_SOURCE
, RTAE.LIABILITY_TAX_CODE ED_ACT_LIABILITY_TAX_CODE
, RTAE.NAME ED_ACT_NAME
, RTAE.RECEIVABLES_TRX_ID ED_ACT_RECEIVABLES_TRX_ID
, RTAE.TAX_CODE_SOURCE ED_ACT_TAX_CODE_SOURCE
, RTAE.TAX_RECOVERABLE_FLAG ED_ACT_TAX_RECOVERABLE_FLAG
, RTAE.TYPE ED_ACT_TYPE
, HE.EVENT_ID EVENT_ID
, HE.LINE_NUMBER LINE_NUMBER
, HE.LANGUAGE LANGUAGE
, HE.LEDGER_ID LEDGER_ID
FROM AR_RECEIVABLES_TRX_ALL RTAE
, AR_XLA_LINES_EXTRACT HE
WHERE RTAE.RECEIVABLES_TRX_ID = HE.ED_ADJ_RECEIVABLES_TRX_ID
AND HE.LEVEL_FLAG = 'L'
AND RTAE.ORG_ID = HE.ORG_ID GROUP BY RTAE.ASSET_TAX_CODE
, RTAE.ATTRIBUTE1
, RTAE.ATTRIBUTE10
, RTAE.ATTRIBUTE11
, RTAE.ATTRIBUTE12
, RTAE.ATTRIBUTE13
, RTAE.ATTRIBUTE14
, RTAE.ATTRIBUTE15
, RTAE.ATTRIBUTE2
, RTAE.ATTRIBUTE3
, RTAE.ATTRIBUTE4
, RTAE.ATTRIBUTE5
, RTAE.ATTRIBUTE6
, RTAE.ATTRIBUTE7
, RTAE.ATTRIBUTE8
, RTAE.ATTRIBUTE9
, RTAE.ATTRIBUTE_CATEGORY
, RTAE.CODE_COMBINATION_ID
, RTAE.DEFAULT_ACCTG_DISTRIBUTION_SET
, RTAE.DESCRIPTION
, RTAE.GL_ACCOUNT_SOURCE
, RTAE.LIABILITY_TAX_CODE
, RTAE.NAME
, RTAE.RECEIVABLES_TRX_ID
, RTAE.TAX_CODE_SOURCE
, RTAE.TAX_RECOVERABLE_FLAG
, RTAE.TYPE
, HE.EVENT_ID
, HE.LINE_NUMBER
, HE.LANGUAGE
, HE.LEDGER_ID