VIEW: APPS.AR_RECEIVABLES_TRX_ACT_S_V

Source

View Text - Preformatted

SELECT /*+ INDEX(HE AR_XLA_LINES_EXTRACT_N1) */ rec_act.asset_tax_code rec_act_asset_tax_code ,rec_act.attribute1 rec_act_attr1 ,rec_act.attribute10 rec_act_attr10 ,rec_act.attribute11 rec_act_attr11 ,rec_act.attribute12 rec_act_attr12 ,rec_act.attribute13 rec_act_attr13 ,rec_act.attribute14 rec_act_attr14 ,rec_act.attribute15 rec_act_attr15 ,rec_act.attribute2 rec_act_attr2 ,rec_act.attribute3 rec_act_attr3 ,rec_act.attribute4 rec_act_attr4 ,rec_act.attribute5 rec_act_attr5 ,rec_act.attribute6 rec_act_attr6 ,rec_act.attribute7 rec_act_attr7 ,rec_act.attribute8 rec_act_attr8 ,rec_act.attribute9 rec_act_attr9 ,rec_act.attribute_category rec_act_attr_cat ,rec_act.code_combination_id rec_act_code_combination_id ,rec_act.default_acctg_distribution_set rec_act_def_acct_distrib_set ,rec_act.description rec_act_description ,rec_act.gl_account_source rec_act_gl_account_source ,rec_act.liability_tax_code rec_act_liability_tax_code ,rec_act.name rec_act_name ,rec_act.receivables_trx_id rec_act_receivables_trx_id ,rec_act.tax_code_source rec_act_tax_code_source ,rec_act.tax_recoverable_flag rec_act_tax_recoverable_flag ,rec_act.type rec_act_type ,he.event_id event_id ,he.line_number line_number ,he.ledger_id ledger_id FROM ar_receivables_trx_all rec_act ,ar_xla_lines_extract he WHERE rec_act.receivables_trx_id = he.receivables_trx_id and rec_act.org_id = he.org_id AND ((he.event_class_code IN ('ADJUSTMENT','BILL') AND he.level_flag = 'H') OR (he.event_class_code IN ('RECEIPT','CREDIT_MEMO') AND he.level_flag = 'L'))

View Text - HTML Formatted

SELECT /*+ INDEX(HE AR_XLA_LINES_EXTRACT_N1) */ REC_ACT.ASSET_TAX_CODE REC_ACT_ASSET_TAX_CODE
, REC_ACT.ATTRIBUTE1 REC_ACT_ATTR1
, REC_ACT.ATTRIBUTE10 REC_ACT_ATTR10
, REC_ACT.ATTRIBUTE11 REC_ACT_ATTR11
, REC_ACT.ATTRIBUTE12 REC_ACT_ATTR12
, REC_ACT.ATTRIBUTE13 REC_ACT_ATTR13
, REC_ACT.ATTRIBUTE14 REC_ACT_ATTR14
, REC_ACT.ATTRIBUTE15 REC_ACT_ATTR15
, REC_ACT.ATTRIBUTE2 REC_ACT_ATTR2
, REC_ACT.ATTRIBUTE3 REC_ACT_ATTR3
, REC_ACT.ATTRIBUTE4 REC_ACT_ATTR4
, REC_ACT.ATTRIBUTE5 REC_ACT_ATTR5
, REC_ACT.ATTRIBUTE6 REC_ACT_ATTR6
, REC_ACT.ATTRIBUTE7 REC_ACT_ATTR7
, REC_ACT.ATTRIBUTE8 REC_ACT_ATTR8
, REC_ACT.ATTRIBUTE9 REC_ACT_ATTR9
, REC_ACT.ATTRIBUTE_CATEGORY REC_ACT_ATTR_CAT
, REC_ACT.CODE_COMBINATION_ID REC_ACT_CODE_COMBINATION_ID
, REC_ACT.DEFAULT_ACCTG_DISTRIBUTION_SET REC_ACT_DEF_ACCT_DISTRIB_SET
, REC_ACT.DESCRIPTION REC_ACT_DESCRIPTION
, REC_ACT.GL_ACCOUNT_SOURCE REC_ACT_GL_ACCOUNT_SOURCE
, REC_ACT.LIABILITY_TAX_CODE REC_ACT_LIABILITY_TAX_CODE
, REC_ACT.NAME REC_ACT_NAME
, REC_ACT.RECEIVABLES_TRX_ID REC_ACT_RECEIVABLES_TRX_ID
, REC_ACT.TAX_CODE_SOURCE REC_ACT_TAX_CODE_SOURCE
, REC_ACT.TAX_RECOVERABLE_FLAG REC_ACT_TAX_RECOVERABLE_FLAG
, REC_ACT.TYPE REC_ACT_TYPE
, HE.EVENT_ID EVENT_ID
, HE.LINE_NUMBER LINE_NUMBER
, HE.LEDGER_ID LEDGER_ID
FROM AR_RECEIVABLES_TRX_ALL REC_ACT
, AR_XLA_LINES_EXTRACT HE
WHERE REC_ACT.RECEIVABLES_TRX_ID = HE.RECEIVABLES_TRX_ID
AND REC_ACT.ORG_ID = HE.ORG_ID
AND ((HE.EVENT_CLASS_CODE IN ('ADJUSTMENT'
, 'BILL')
AND HE.LEVEL_FLAG = 'H') OR (HE.EVENT_CLASS_CODE IN ('RECEIPT'
, 'CREDIT_MEMO')
AND HE.LEVEL_FLAG = 'L'))