AR_RECEIVABLES_TRX_ED_L

Details

Schema: FUSION
Object owner: AR
Object type: VIEW

Columns

Name
ED_ACT_ASSET_TAX_CODE ED_ACT_ATTR1 ED_ACT_ATTR10 ED_ACT_ATTR11 ED_ACT_ATTR12 ED_ACT_ATTR13 ED_ACT_ATTR14 ED_ACT_ATTR15 ED_ACT_ATTR2 ED_ACT_ATTR3 ED_ACT_ATTR4 ED_ACT_ATTR5 ED_ACT_ATTR6 ED_ACT_ATTR7 ED_ACT_ATTR8 ED_ACT_ATTR9 ED_ACT_ATTR_CAT ED_ACT_CODE_COMBINATION_ID ED_ACT_DEF_ACCT_DISTRIB_SET ED_ACT_DESCRIPTION ED_ACT_GL_ACCOUNT_SOURCE ED_ACT_LIABILITY_TAX_CODE ED_ACT_NAME ED_ACT_RECEIVABLES_TRX_ID ED_ACT_TAX_CODE_SOURCE ED_ACT_TAX_RECOVERABLE_FLAG ED_ACT_TYPE EVENT_ID LINE_NUMBER LANGUAGE LEDGER_ID

Name

ED_ACT_ASSET_TAX_CODE

ED_ACT_ATTR1

ED_ACT_ATTR10

ED_ACT_ATTR11

ED_ACT_ATTR12

ED_ACT_ATTR13

ED_ACT_ATTR14

ED_ACT_ATTR15

ED_ACT_ATTR2

ED_ACT_ATTR3

ED_ACT_ATTR4

ED_ACT_ATTR5

ED_ACT_ATTR6

ED_ACT_ATTR7

ED_ACT_ATTR8

ED_ACT_ATTR9

ED_ACT_ATTR_CAT

ED_ACT_CODE_COMBINATION_ID

ED_ACT_DEF_ACCT_DISTRIB_SET

ED_ACT_DESCRIPTION

ED_ACT_GL_ACCOUNT_SOURCE

ED_ACT_LIABILITY_TAX_CODE

ED_ACT_NAME

ED_ACT_RECEIVABLES_TRX_ID

ED_ACT_TAX_CODE_SOURCE

ED_ACT_TAX_RECOVERABLE_FLAG

ED_ACT_TYPE

EVENT_ID

LINE_NUMBER

LANGUAGE

LEDGER_ID

Query

SQL_Statement
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

SQL_Statement

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