AR_RECEIVABLE_APPS_L

Details

Schema: FUSION
Object owner: AR
Object type: VIEW

Columns

Name
APP_APPLICATION_ID APP_APPLICATION_REF_NUM APP_APPLICATION_REF_TYPE APP_APPLICATION_TYPE APP_APPLY_DATE APP_CODE_COMBINATION_ID APP_COMMENTS APP_CONFIRMED_FLAG APP_EARNED_DISCOUNT_CCID APP_EDISC_TAX_ACCT_RULE APP_GL_DATE APP_REVERSAL_GL_DATE APP_STATUS APP_TAX_CODE APP_TRANS_TO_RECEIPT_RATE APP_UNEARNED_DISCOUNT_CCID APP_UNEDISC_TAX_ACCT_RULE APP_APPLICATION_REF_REASON APP_ATTR1 APP_ATTR10 APP_ATTR11 APP_ATTR12 APP_ATTR13 APP_ATTR14 APP_ATTR15 APP_ATTR2 APP_ATTR3 APP_ATTR4 APP_ATTR5 APP_ATTR6 APP_ATTR7 APP_ATTR8 APP_ATTR9 APP_ATTR_CAT APP_GLOBAL_ATTR1 APP_GLOBAL_ATTR10 APP_GLOBAL_ATTR11 APP_GLOBAL_ATTR12 APP_GLOBAL_ATTR13 APP_GLOBAL_ATTR14 APP_GLOBAL_ATTR15 APP_GLOBAL_ATTR16 APP_GLOBAL_ATTR17 APP_GLOBAL_ATTR18 APP_GLOBAL_ATTR19 APP_GLOBAL_ATTR2 APP_GLOBAL_ATTR20 APP_GLOBAL_ATTR3 APP_GLOBAL_ATTR4 APP_GLOBAL_ATTR5 APP_GLOBAL_ATTR6 APP_GLOBAL_ATTR7 APP_GLOBAL_ATTR8 APP_GLOBAL_ATTR9 APP_GLOBAL_ATTR_NUM1 APP_GLOBAL_ATTR_NUM2 APP_GLOBAL_ATTR_NUM3 APP_GLOBAL_ATTR_NUM4 APP_GLOBAL_ATTR_NUM5 APP_GLOBAL_ATTR_DATE1 APP_GLOBAL_ATTR_DATE2 APP_GLOBAL_ATTR_DATE3 APP_GLOBAL_ATTR_DATE4 APP_GLOBAL_ATTR_DATE5 APP_GLOBAL_ATTR_CAT APP_USSGL_TRX_CODE APP_USSGL_TRX_CODE_CT EVENT_ID XLA_PARTY_TYPE APP_CRH_STATUS LINE_NUMBER LANGUAGE LEDGER_ID

Name

APP_APPLICATION_ID

APP_APPLICATION_REF_NUM

APP_APPLICATION_REF_TYPE

APP_APPLICATION_TYPE

APP_APPLY_DATE

APP_CODE_COMBINATION_ID

APP_COMMENTS

APP_CONFIRMED_FLAG

APP_EARNED_DISCOUNT_CCID

APP_EDISC_TAX_ACCT_RULE

APP_GL_DATE

APP_REVERSAL_GL_DATE

APP_STATUS

APP_TAX_CODE

APP_TRANS_TO_RECEIPT_RATE

APP_UNEARNED_DISCOUNT_CCID

APP_UNEDISC_TAX_ACCT_RULE

APP_APPLICATION_REF_REASON

APP_ATTR1

APP_ATTR10

APP_ATTR11

APP_ATTR12

APP_ATTR13

APP_ATTR14

APP_ATTR15

APP_ATTR2

APP_ATTR3

APP_ATTR4

APP_ATTR5

APP_ATTR6

APP_ATTR7

APP_ATTR8

APP_ATTR9

APP_ATTR_CAT

APP_GLOBAL_ATTR1

APP_GLOBAL_ATTR10

APP_GLOBAL_ATTR11

APP_GLOBAL_ATTR12

APP_GLOBAL_ATTR13

APP_GLOBAL_ATTR14

APP_GLOBAL_ATTR15

APP_GLOBAL_ATTR16

APP_GLOBAL_ATTR17

APP_GLOBAL_ATTR18

APP_GLOBAL_ATTR19

APP_GLOBAL_ATTR2

APP_GLOBAL_ATTR20

APP_GLOBAL_ATTR3

APP_GLOBAL_ATTR4

APP_GLOBAL_ATTR5

APP_GLOBAL_ATTR6

APP_GLOBAL_ATTR7

APP_GLOBAL_ATTR8

APP_GLOBAL_ATTR9

APP_GLOBAL_ATTR_NUM1

APP_GLOBAL_ATTR_NUM2

APP_GLOBAL_ATTR_NUM3

APP_GLOBAL_ATTR_NUM4

APP_GLOBAL_ATTR_NUM5

APP_GLOBAL_ATTR_DATE1

APP_GLOBAL_ATTR_DATE2

APP_GLOBAL_ATTR_DATE3

APP_GLOBAL_ATTR_DATE4

APP_GLOBAL_ATTR_DATE5

APP_GLOBAL_ATTR_CAT

APP_USSGL_TRX_CODE

APP_USSGL_TRX_CODE_CT

EVENT_ID

XLA_PARTY_TYPE

APP_CRH_STATUS

LINE_NUMBER

LANGUAGE

LEDGER_ID

Query

SQL_Statement
SELECT /+ INDEX(HE AR_XLA_LINES_EXTRACT_N1) / raa.receivable_application_id app_application_id , raa.application_ref_num app_application_ref_num , raa.application_ref_type app_application_ref_type , raa.application_type app_application_type , raa.apply_date app_apply_date , raa.code_combination_id app_code_combination_id , raa.comments app_comments , raa.confirmed_flag app_confirmed_flag , raa.earned_discount_ccid app_earned_discount_ccid , raa.edisc_tax_acct_rule app_edisc_tax_acct_rule , raa.gl_date app_gl_date , raa.reversal_gl_date app_reversal_gl_date , raa.status app_status , raa.tax_code app_tax_code , raa.trans_to_receipt_rate app_trans_to_receipt_rate , raa.unearned_discount_ccid app_unearned_discount_ccid , raa.unedisc_tax_acct_rule app_unedisc_tax_acct_rule , raa.application_ref_reason APP_APPLICATION_REF_REASON , raa.attribute1 APP_ATTR1 , raa.attribute10 APP_ATTR10 , raa.attribute11 APP_ATTR11 , raa.attribute12 APP_ATTR12 , raa.attribute13 APP_ATTR13 , raa.attribute14 APP_ATTR14 , raa.attribute15 APP_ATTR15 , raa.attribute2 APP_ATTR2 , raa.attribute3 APP_ATTR3 , raa.attribute4 APP_ATTR4 , raa.attribute5 APP_ATTR5 , raa.attribute6 APP_ATTR6 , raa.attribute7 APP_ATTR7 , raa.attribute8 APP_ATTR8 , raa.attribute9 APP_ATTR9 , raa.attribute_category APP_ATTR_CAT , raa.global_attribute1 APP_GLOBAL_ATTR1 , raa.global_attribute10 APP_GLOBAL_ATTR10 , raa.global_attribute11 APP_GLOBAL_ATTR11 , raa.global_attribute12 APP_GLOBAL_ATTR12 , raa.global_attribute13 APP_GLOBAL_ATTR13 , raa.global_attribute14 APP_GLOBAL_ATTR14 , raa.global_attribute15 APP_GLOBAL_ATTR15 , raa.global_attribute16 APP_GLOBAL_ATTR16 , raa.global_attribute17 APP_GLOBAL_ATTR17 , raa.global_attribute18 APP_GLOBAL_ATTR18 , raa.global_attribute19 APP_GLOBAL_ATTR19 , raa.global_attribute2 APP_GLOBAL_ATTR2 , raa.global_attribute20 APP_GLOBAL_ATTR20 , raa.global_attribute3 APP_GLOBAL_ATTR3 , raa.global_attribute4 APP_GLOBAL_ATTR4 , raa.global_attribute5 APP_GLOBAL_ATTR5 , raa.global_attribute6 APP_GLOBAL_ATTR6 , raa.global_attribute7 APP_GLOBAL_ATTR7 , raa.global_attribute8 APP_GLOBAL_ATTR8 , raa.global_attribute9 APP_GLOBAL_ATTR9 , raa.global_attribute_number1 APP_GLOBAL_ATTR_NUM1 , raa.global_attribute_number2 APP_GLOBAL_ATTR_NUM2 , raa.global_attribute_number3 APP_GLOBAL_ATTR_NUM3 , raa.global_attribute_number4 APP_GLOBAL_ATTR_NUM4 , raa.global_attribute_number5 APP_GLOBAL_ATTR_NUM5 , raa.global_attribute_date1 APP_GLOBAL_ATTR_DATE1 , raa.global_attribute_date2 APP_GLOBAL_ATTR_DATE2, raa.global_attribute_date3 APP_GLOBAL_ATTR_DATE3 , raa.global_attribute_date4 APP_GLOBAL_ATTR_DATE4 , raa.global_attribute_date5 APP_GLOBAL_ATTR_DATE5 , raa.global_attribute_category APP_GLOBAL_ATTR_CAT , raa.USSGL_TRANSACTION_CODE APP_USSGL_TRX_CODE , raa.ussgl_transaction_code_context APP_USSGL_TRX_CODE_CT , he.event_id event_id , 'C' xla_party_type , he.crh_status app_crh_status , he.line_number line_number , he.language language , he.ledger_id ledger_id FROM ar_receivable_applications_all raa , ar_xla_lines_extract he WHERE raa.event_id = he.event_id AND he.source_id = raa.receivable_application_id AND he.level_flag = 'L' AND raa.status IN ('APP', 'ACC', 'ACTIVITY', 'OTHER ACC') GROUP BY raa.receivable_application_id , raa.application_ref_num , raa.application_ref_type , raa.application_type , raa.apply_date , raa.code_combination_id , raa.comments , raa.confirmed_flag , raa.earned_discount_ccid , raa.edisc_tax_acct_rule , raa.gl_date , raa.reversal_gl_date , raa.status , raa.tax_code , raa.trans_to_receipt_rate , raa.unearned_discount_ccid , raa.unedisc_tax_acct_rule , raa.application_ref_reason , raa.attribute1 , raa.attribute10 , raa.attribute11 , raa.attribute12 , raa.attribute13 , raa.attribute14 , raa.attribute15 , raa.attribute2 , raa.attribute3 , raa.attribute4 , raa.attribute5 , raa.attribute6 , raa.attribute7 , raa.attribute8 , raa.attribute9 , raa.attribute_category , raa.global_attribute1 , raa.global_attribute10 , raa.global_attribute11 , raa.global_attribute12 , raa.global_attribute13 , raa.global_attribute14 , raa.global_attribute15 , raa.global_attribute16 , raa.global_attribute17 , raa.global_attribute18 , raa.global_attribute19 , raa.global_attribute2 , raa.global_attribute20 , raa.global_attribute3 , raa.global_attribute4 , raa.global_attribute5 , raa.global_attribute6 , raa.global_attribute7 , raa.global_attribute8 , raa.global_attribute9 , raa.global_attribute_number1 , raa.global_attribute_number2 , raa.global_attribute_number3 , raa.global_attribute_number4 , raa.global_attribute_number5 , raa.global_attribute_date1 , raa.global_attribute_date2 , raa.global_attribute_date3 , raa.global_attribute_date4 , raa.global_attribute_date5 , raa.global_attribute_category , raa.USSGL_TRANSACTION_CODE , raa.ussgl_transaction_code_context , he.event_id , 'C' , he.crh_status , he.line_number , he.language , he.ledger_id

SQL_Statement

SELECT /*+ INDEX(HE AR_XLA_LINES_EXTRACT_N1) */ raa.receivable_application_id app_application_id ,

raa.application_ref_num app_application_ref_num ,

raa.application_ref_type app_application_ref_type ,

raa.application_type app_application_type ,

raa.apply_date app_apply_date ,

raa.code_combination_id app_code_combination_id ,

raa.comments app_comments ,

raa.confirmed_flag app_confirmed_flag ,

raa.earned_discount_ccid app_earned_discount_ccid ,

raa.edisc_tax_acct_rule app_edisc_tax_acct_rule ,

raa.gl_date app_gl_date ,

raa.reversal_gl_date app_reversal_gl_date ,

raa.status app_status ,

raa.tax_code app_tax_code ,

raa.trans_to_receipt_rate app_trans_to_receipt_rate ,

raa.unearned_discount_ccid app_unearned_discount_ccid ,

raa.unedisc_tax_acct_rule app_unedisc_tax_acct_rule ,

raa.application_ref_reason APP_APPLICATION_REF_REASON ,

raa.attribute1 APP_ATTR1 ,

raa.attribute10 APP_ATTR10 ,

raa.attribute11 APP_ATTR11 ,

raa.attribute12 APP_ATTR12 ,

raa.attribute13 APP_ATTR13 ,

raa.attribute14 APP_ATTR14 ,

raa.attribute15 APP_ATTR15 ,

raa.attribute2 APP_ATTR2 ,

raa.attribute3 APP_ATTR3 ,

raa.attribute4 APP_ATTR4 ,

raa.attribute5 APP_ATTR5 ,

raa.attribute6 APP_ATTR6 ,

raa.attribute7 APP_ATTR7 ,

raa.attribute8 APP_ATTR8 ,

raa.attribute9 APP_ATTR9 ,

raa.attribute_category APP_ATTR_CAT ,

raa.global_attribute1 APP_GLOBAL_ATTR1 ,

raa.global_attribute10 APP_GLOBAL_ATTR10 ,

raa.global_attribute11 APP_GLOBAL_ATTR11 ,

raa.global_attribute12 APP_GLOBAL_ATTR12 ,

raa.global_attribute13 APP_GLOBAL_ATTR13 ,

raa.global_attribute14 APP_GLOBAL_ATTR14 ,

raa.global_attribute15 APP_GLOBAL_ATTR15 ,

raa.global_attribute16 APP_GLOBAL_ATTR16 ,

raa.global_attribute17 APP_GLOBAL_ATTR17 ,

raa.global_attribute18 APP_GLOBAL_ATTR18 ,

raa.global_attribute19 APP_GLOBAL_ATTR19 ,

raa.global_attribute2 APP_GLOBAL_ATTR2 ,

raa.global_attribute20 APP_GLOBAL_ATTR20 ,

raa.global_attribute3 APP_GLOBAL_ATTR3 ,

raa.global_attribute4 APP_GLOBAL_ATTR4 ,

raa.global_attribute5 APP_GLOBAL_ATTR5 ,

raa.global_attribute6 APP_GLOBAL_ATTR6 ,

raa.global_attribute7 APP_GLOBAL_ATTR7 ,

raa.global_attribute8 APP_GLOBAL_ATTR8 ,

raa.global_attribute9 APP_GLOBAL_ATTR9 ,

raa.global_attribute_number1 APP_GLOBAL_ATTR_NUM1 ,

raa.global_attribute_number2 APP_GLOBAL_ATTR_NUM2 ,

raa.global_attribute_number3 APP_GLOBAL_ATTR_NUM3 ,

raa.global_attribute_number4 APP_GLOBAL_ATTR_NUM4 ,

raa.global_attribute_number5 APP_GLOBAL_ATTR_NUM5 ,

raa.global_attribute_date1 APP_GLOBAL_ATTR_DATE1 ,

raa.global_attribute_date2 APP_GLOBAL_ATTR_DATE2,

raa.global_attribute_date3 APP_GLOBAL_ATTR_DATE3 ,

raa.global_attribute_date4 APP_GLOBAL_ATTR_DATE4 ,

raa.global_attribute_date5 APP_GLOBAL_ATTR_DATE5 ,

raa.global_attribute_category APP_GLOBAL_ATTR_CAT ,

raa.USSGL_TRANSACTION_CODE APP_USSGL_TRX_CODE ,

raa.ussgl_transaction_code_context APP_USSGL_TRX_CODE_CT ,

he.event_id event_id ,

'C' xla_party_type ,

he.crh_status app_crh_status ,

he.line_number line_number ,

he.language language ,

he.ledger_id ledger_id

FROM ar_receivable_applications_all raa ,

ar_xla_lines_extract he

WHERE raa.event_id = he.event_id

AND he.source_id = raa.receivable_application_id

AND he.level_flag = 'L'

AND raa.status IN ('APP',

'ACC',

'ACTIVITY',

'OTHER ACC') GROUP BY raa.receivable_application_id ,

raa.application_ref_num ,

raa.application_ref_type ,

raa.application_type ,

raa.apply_date ,

raa.code_combination_id ,

raa.comments ,

raa.confirmed_flag ,

raa.earned_discount_ccid ,

raa.edisc_tax_acct_rule ,

raa.gl_date ,

raa.reversal_gl_date ,

raa.status ,

raa.tax_code ,

raa.trans_to_receipt_rate ,

raa.unearned_discount_ccid ,

raa.unedisc_tax_acct_rule ,

raa.application_ref_reason ,

raa.attribute1 ,

raa.attribute10 ,

raa.attribute11 ,

raa.attribute12 ,

raa.attribute13 ,

raa.attribute14 ,

raa.attribute15 ,

raa.attribute2 ,

raa.attribute3 ,

raa.attribute4 ,

raa.attribute5 ,

raa.attribute6 ,

raa.attribute7 ,

raa.attribute8 ,

raa.attribute9 ,

raa.attribute_category ,

raa.global_attribute1 ,

raa.global_attribute10 ,

raa.global_attribute11 ,

raa.global_attribute12 ,

raa.global_attribute13 ,

raa.global_attribute14 ,

raa.global_attribute15 ,

raa.global_attribute16 ,

raa.global_attribute17 ,

raa.global_attribute18 ,

raa.global_attribute19 ,

raa.global_attribute2 ,

raa.global_attribute20 ,

raa.global_attribute3 ,

raa.global_attribute4 ,

raa.global_attribute5 ,

raa.global_attribute6 ,

raa.global_attribute7 ,

raa.global_attribute8 ,

raa.global_attribute9 ,

raa.global_attribute_number1 ,

raa.global_attribute_number2 ,

raa.global_attribute_number3 ,

raa.global_attribute_number4 ,

raa.global_attribute_number5 ,

raa.global_attribute_date1 ,

raa.global_attribute_date2 ,

raa.global_attribute_date3 ,

raa.global_attribute_date4 ,

raa.global_attribute_date5 ,

raa.global_attribute_category ,

raa.USSGL_TRANSACTION_CODE ,

raa.ussgl_transaction_code_context ,

he.event_id ,

'C' ,

he.crh_status ,

he.line_number ,

he.language ,

he.ledger_id