VIEW: APPS.AR_RECEIVABLE_APPS_L_V

Source

View Text - Preformatted

SELECT /*+ INDEX(li 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_attribute2 APP_GLOBAL_ATTR2 ,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_category APP_GLOBAL_ATTR_CAT ,raa.USSGL_TRANSACTION_CODE APP_USSGL_TRX_CODE ,raa.ussgl_transaction_code_context APP_USSGL_TRX_CODE_CT ,li.event_id event_id ,'C' xla_party_type ,li.crh_status app_crh_status ,li.line_number line_number ,li.language language ,li.ledger_id ledger_id FROM ar_xla_lines_extract li, ar_receivable_applications_all raa WHERE li.event_id = raa.event_id AND li.source_id = raa.receivable_application_id AND li.level_flag = 'L' AND li.posting_entity = 'CRH' AND li.source_table = 'RA' AND li.mfar_additional_entry = 'N' UNION /******************************************* * RA Classified under Posting Entity APP * *******************************************/ SELECT /*+ INDEX(licr AR_XLA_LINES_EXTRACT_N1) INDEX(litrx 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_attribute2 APP_GLOBAL_ATTR2 ,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_category APP_GLOBAL_ATTR_CAT ,raa.USSGL_TRANSACTION_CODE APP_USSGL_TRX_CODE ,raa.ussgl_transaction_code_context APP_USSGL_TRX_CODE_CT ,licr.event_id event_id ,'C' xla_party_type ,licr.crh_status app_crh_status ,licr.line_number line_number ,licr.language language ,licr.ledger_id ledger_id FROM ar_xla_lines_extract licr, ar_xla_lines_extract litrx, ar_receivable_applications_all raa WHERE licr.event_id = raa.event_id AND licr.source_id = raa.receivable_application_id AND licr.posting_entity = 'APP' AND licr.level_flag = 'L' AND licr.cash_receipt_id IS NOT NULL AND licr.customer_trx_id IS NULL AND licr.from_to_flag = 'F' AND litrx.posting_entity = 'APP' AND litrx.level_flag = 'L' AND litrx.cash_receipt_id IS NULL AND litrx.customer_trx_id IS NOT NULL AND litrx.from_to_flag = 'T' AND licr.header_table_id = litrx.header_table_id AND licr.event_id = litrx.event_id AND licr.line_id = litrx.line_id AND licr.event_type_code IN ('RECP_CREATE','RECP_UPDATE','RECP_RATE_ADJUST','RECP_REVERSE') AND NVL(licr.ADDITIONAL_CHAR1,'XX') <> 'R12_11ICASH_POST' AND NVL(litrx.ADDITIONAL_CHAR1,'XX') <> 'R12_11ICASH_POST' AND licr.mfar_additional_entry = 'N' AND litrx.mfar_additional_entry = 'N' UNION /******************** * CM APP doc * ********************/ SELECT /*+ INDEX(li 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_attribute2 APP_GLOBAL_ATTR2 ,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_category APP_GLOBAL_ATTR_CAT ,raa.USSGL_TRANSACTION_CODE APP_USSGL_TRX_CODE ,raa.ussgl_transaction_code_context APP_USSGL_TRX_CODE_CT ,li.event_id event_id ,'C' xla_party_type ,li.crh_status app_crh_status ,li.line_number line_number ,li.language language ,li.ledger_id ledger_id FROM ar_xla_lines_extract li, ar_receivable_applications_all raa WHERE li.event_id = raa.event_id AND li.source_id = raa.receivable_application_id AND li.posting_entity = 'APP' AND li.level_flag = 'L' AND li.customer_trx_id IS NOT NULL AND li.from_to_flag = 'F' AND li.event_type_code IN ('CM_CREATE','CM_UPDATE') AND NVL(li.ADDITIONAL_CHAR1,'XX') <> 'R12_11ICASH_POST' AND li.mfar_additional_entry = 'N' UNION SELECT /*+ INDEX(li 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_attribute2 APP_GLOBAL_ATTR2 ,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_category APP_GLOBAL_ATTR_CAT ,raa.USSGL_TRANSACTION_CODE APP_USSGL_TRX_CODE ,raa.ussgl_transaction_code_context APP_USSGL_TRX_CODE_CT ,li.event_id event_id ,'C' xla_party_type ,li.crh_status app_crh_status ,li.line_number line_number ,li.language language ,li.ledger_id ledger_id FROM ar_xla_lines_extract li, ar_receivable_applications_all raa WHERE li.event_id = raa.event_id AND li.source_id = raa.receivable_application_id AND li.posting_entity = 'APP' AND li.level_flag = 'L' AND li.customer_trx_id IS NOT NULL AND li.from_to_flag = 'T' AND li.event_type_code IN ('CM_CREATE','CM_UPDATE') AND NVL(li.ADDITIONAL_CHAR1,'XX') <> 'R12_11ICASH_POST' AND li.mfar_additional_entry = 'N' UNION /******************************* * Cash Basis Upgrade RECP APP * *******************************/ SELECT /*+ INDEX(licr AR_XLA_LINES_EXTRACT_N1) INDEX(litrx 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_attribute2 APP_GLOBAL_ATTR2 ,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_category APP_GLOBAL_ATTR_CAT ,raa.USSGL_TRANSACTION_CODE APP_USSGL_TRX_CODE ,raa.ussgl_transaction_code_context APP_USSGL_TRX_CODE_CT ,licr.event_id event_id ,'C' xla_party_type ,licr.crh_status app_crh_status ,licr.line_number line_number ,licr.language language ,licr.ledger_id ledger_id FROM ar_xla_lines_extract licr, ar_xla_lines_extract litrx, ar_receivable_applications_all raa, ar_cash_basis_dists_all dist WHERE licr.event_id = raa.event_id AND licr.source_id = raa.receivable_application_id AND licr.posting_entity = 'APP' AND licr.level_flag = 'L' AND licr.cash_receipt_id IS NOT NULL AND licr.customer_trx_id IS NULL AND licr.from_to_flag = 'F' AND litrx.posting_entity = 'APP' AND litrx.level_flag = 'L' AND litrx.cash_receipt_id IS NULL AND litrx.customer_trx_id IS NOT NULL AND litrx.from_to_flag = 'T' AND licr.header_table_id = litrx.header_table_id AND licr.event_id = litrx.event_id AND dist.receivable_Application_id = litrx.header_table_id AND dist.cash_basis_distribution_id = licr.line_id AND dist.cash_basis_distribution_id = litrx.line_id AND licr.event_type_code IN ('RECP_CREATE','RECP_UPDATE','RECP_RATE_ADJUST','RECP_REVERSE') AND licr.ADDITIONAL_CHAR1 = 'R12_11ICASH_POST' AND litrx.ADDITIONAL_CHAR1 = 'R12_11ICASH_POST' AND licr.mfar_additional_entry = 'N' AND litrx.mfar_additional_entry = 'N' UNION /******************************* * MFAR Additional Entries * *******************************/ SELECT /*+ INDEX(li 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_attribute2 APP_GLOBAL_ATTR2 ,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_category APP_GLOBAL_ATTR_CAT ,raa.USSGL_TRANSACTION_CODE APP_USSGL_TRX_CODE ,raa.ussgl_transaction_code_context APP_USSGL_TRX_CODE_CT ,li.event_id event_id ,'C' xla_party_type ,li.crh_status app_crh_status ,li.line_number line_number ,li.language language ,li.ledger_id ledger_id FROM ar_xla_lines_extract li, ar_receivable_applications_all raa WHERE li.event_id = raa.event_id AND li.source_id = raa.receivable_application_id AND li.source_table = 'RA' AND li.level_flag = 'L' AND li.mfar_additional_entry = 'Y'

View Text - HTML Formatted

SELECT /*+ INDEX(LI 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_ATTRIBUTE2 APP_GLOBAL_ATTR2
, 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_CATEGORY APP_GLOBAL_ATTR_CAT
, RAA.USSGL_TRANSACTION_CODE APP_USSGL_TRX_CODE
, RAA.USSGL_TRANSACTION_CODE_CONTEXT APP_USSGL_TRX_CODE_CT
, LI.EVENT_ID EVENT_ID
, 'C' XLA_PARTY_TYPE
, LI.CRH_STATUS APP_CRH_STATUS
, LI.LINE_NUMBER LINE_NUMBER
, LI.LANGUAGE LANGUAGE
, LI.LEDGER_ID LEDGER_ID
FROM AR_XLA_LINES_EXTRACT LI
, AR_RECEIVABLE_APPLICATIONS_ALL RAA
WHERE LI.EVENT_ID = RAA.EVENT_ID
AND LI.SOURCE_ID = RAA.RECEIVABLE_APPLICATION_ID
AND LI.LEVEL_FLAG = 'L'
AND LI.POSTING_ENTITY = 'CRH'
AND LI.SOURCE_TABLE = 'RA'
AND LI.MFAR_ADDITIONAL_ENTRY = 'N' UNION /******************************************* * RA CLASSIFIED UNDER POSTING ENTITY APP * *******************************************/ SELECT /*+ INDEX(LICR AR_XLA_LINES_EXTRACT_N1) INDEX(LITRX 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_ATTRIBUTE2 APP_GLOBAL_ATTR2
, 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_CATEGORY APP_GLOBAL_ATTR_CAT
, RAA.USSGL_TRANSACTION_CODE APP_USSGL_TRX_CODE
, RAA.USSGL_TRANSACTION_CODE_CONTEXT APP_USSGL_TRX_CODE_CT
, LICR.EVENT_ID EVENT_ID
, 'C' XLA_PARTY_TYPE
, LICR.CRH_STATUS APP_CRH_STATUS
, LICR.LINE_NUMBER LINE_NUMBER
, LICR.LANGUAGE LANGUAGE
, LICR.LEDGER_ID LEDGER_ID
FROM AR_XLA_LINES_EXTRACT LICR
, AR_XLA_LINES_EXTRACT LITRX
, AR_RECEIVABLE_APPLICATIONS_ALL RAA
WHERE LICR.EVENT_ID = RAA.EVENT_ID
AND LICR.SOURCE_ID = RAA.RECEIVABLE_APPLICATION_ID
AND LICR.POSTING_ENTITY = 'APP'
AND LICR.LEVEL_FLAG = 'L'
AND LICR.CASH_RECEIPT_ID IS NOT NULL
AND LICR.CUSTOMER_TRX_ID IS NULL
AND LICR.FROM_TO_FLAG = 'F'
AND LITRX.POSTING_ENTITY = 'APP'
AND LITRX.LEVEL_FLAG = 'L'
AND LITRX.CASH_RECEIPT_ID IS NULL
AND LITRX.CUSTOMER_TRX_ID IS NOT NULL
AND LITRX.FROM_TO_FLAG = 'T'
AND LICR.HEADER_TABLE_ID = LITRX.HEADER_TABLE_ID
AND LICR.EVENT_ID = LITRX.EVENT_ID
AND LICR.LINE_ID = LITRX.LINE_ID
AND LICR.EVENT_TYPE_CODE IN ('RECP_CREATE'
, 'RECP_UPDATE'
, 'RECP_RATE_ADJUST'
, 'RECP_REVERSE')
AND NVL(LICR.ADDITIONAL_CHAR1
, 'XX') <> 'R12_11ICASH_POST'
AND NVL(LITRX.ADDITIONAL_CHAR1
, 'XX') <> 'R12_11ICASH_POST'
AND LICR.MFAR_ADDITIONAL_ENTRY = 'N'
AND LITRX.MFAR_ADDITIONAL_ENTRY = 'N' UNION /******************** * CM APP DOC * ********************/ SELECT /*+ INDEX(LI 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_ATTRIBUTE2 APP_GLOBAL_ATTR2
, 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_CATEGORY APP_GLOBAL_ATTR_CAT
, RAA.USSGL_TRANSACTION_CODE APP_USSGL_TRX_CODE
, RAA.USSGL_TRANSACTION_CODE_CONTEXT APP_USSGL_TRX_CODE_CT
, LI.EVENT_ID EVENT_ID
, 'C' XLA_PARTY_TYPE
, LI.CRH_STATUS APP_CRH_STATUS
, LI.LINE_NUMBER LINE_NUMBER
, LI.LANGUAGE LANGUAGE
, LI.LEDGER_ID LEDGER_ID
FROM AR_XLA_LINES_EXTRACT LI
, AR_RECEIVABLE_APPLICATIONS_ALL RAA
WHERE LI.EVENT_ID = RAA.EVENT_ID
AND LI.SOURCE_ID = RAA.RECEIVABLE_APPLICATION_ID
AND LI.POSTING_ENTITY = 'APP'
AND LI.LEVEL_FLAG = 'L'
AND LI.CUSTOMER_TRX_ID IS NOT NULL
AND LI.FROM_TO_FLAG = 'F'
AND LI.EVENT_TYPE_CODE IN ('CM_CREATE'
, 'CM_UPDATE')
AND NVL(LI.ADDITIONAL_CHAR1
, 'XX') <> 'R12_11ICASH_POST'
AND LI.MFAR_ADDITIONAL_ENTRY = 'N' UNION SELECT /*+ INDEX(LI 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_ATTRIBUTE2 APP_GLOBAL_ATTR2
, 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_CATEGORY APP_GLOBAL_ATTR_CAT
, RAA.USSGL_TRANSACTION_CODE APP_USSGL_TRX_CODE
, RAA.USSGL_TRANSACTION_CODE_CONTEXT APP_USSGL_TRX_CODE_CT
, LI.EVENT_ID EVENT_ID
, 'C' XLA_PARTY_TYPE
, LI.CRH_STATUS APP_CRH_STATUS
, LI.LINE_NUMBER LINE_NUMBER
, LI.LANGUAGE LANGUAGE
, LI.LEDGER_ID LEDGER_ID
FROM AR_XLA_LINES_EXTRACT LI
, AR_RECEIVABLE_APPLICATIONS_ALL RAA
WHERE LI.EVENT_ID = RAA.EVENT_ID
AND LI.SOURCE_ID = RAA.RECEIVABLE_APPLICATION_ID
AND LI.POSTING_ENTITY = 'APP'
AND LI.LEVEL_FLAG = 'L'
AND LI.CUSTOMER_TRX_ID IS NOT NULL
AND LI.FROM_TO_FLAG = 'T'
AND LI.EVENT_TYPE_CODE IN ('CM_CREATE'
, 'CM_UPDATE')
AND NVL(LI.ADDITIONAL_CHAR1
, 'XX') <> 'R12_11ICASH_POST'
AND LI.MFAR_ADDITIONAL_ENTRY = 'N' UNION /******************************* * CASH BASIS UPGRADE RECP APP * *******************************/ SELECT /*+ INDEX(LICR AR_XLA_LINES_EXTRACT_N1) INDEX(LITRX 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_ATTRIBUTE2 APP_GLOBAL_ATTR2
, 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_CATEGORY APP_GLOBAL_ATTR_CAT
, RAA.USSGL_TRANSACTION_CODE APP_USSGL_TRX_CODE
, RAA.USSGL_TRANSACTION_CODE_CONTEXT APP_USSGL_TRX_CODE_CT
, LICR.EVENT_ID EVENT_ID
, 'C' XLA_PARTY_TYPE
, LICR.CRH_STATUS APP_CRH_STATUS
, LICR.LINE_NUMBER LINE_NUMBER
, LICR.LANGUAGE LANGUAGE
, LICR.LEDGER_ID LEDGER_ID
FROM AR_XLA_LINES_EXTRACT LICR
, AR_XLA_LINES_EXTRACT LITRX
, AR_RECEIVABLE_APPLICATIONS_ALL RAA
, AR_CASH_BASIS_DISTS_ALL DIST
WHERE LICR.EVENT_ID = RAA.EVENT_ID
AND LICR.SOURCE_ID = RAA.RECEIVABLE_APPLICATION_ID
AND LICR.POSTING_ENTITY = 'APP'
AND LICR.LEVEL_FLAG = 'L'
AND LICR.CASH_RECEIPT_ID IS NOT NULL
AND LICR.CUSTOMER_TRX_ID IS NULL
AND LICR.FROM_TO_FLAG = 'F'
AND LITRX.POSTING_ENTITY = 'APP'
AND LITRX.LEVEL_FLAG = 'L'
AND LITRX.CASH_RECEIPT_ID IS NULL
AND LITRX.CUSTOMER_TRX_ID IS NOT NULL
AND LITRX.FROM_TO_FLAG = 'T'
AND LICR.HEADER_TABLE_ID = LITRX.HEADER_TABLE_ID
AND LICR.EVENT_ID = LITRX.EVENT_ID
AND DIST.RECEIVABLE_APPLICATION_ID = LITRX.HEADER_TABLE_ID
AND DIST.CASH_BASIS_DISTRIBUTION_ID = LICR.LINE_ID
AND DIST.CASH_BASIS_DISTRIBUTION_ID = LITRX.LINE_ID
AND LICR.EVENT_TYPE_CODE IN ('RECP_CREATE'
, 'RECP_UPDATE'
, 'RECP_RATE_ADJUST'
, 'RECP_REVERSE')
AND LICR.ADDITIONAL_CHAR1 = 'R12_11ICASH_POST'
AND LITRX.ADDITIONAL_CHAR1 = 'R12_11ICASH_POST'
AND LICR.MFAR_ADDITIONAL_ENTRY = 'N'
AND LITRX.MFAR_ADDITIONAL_ENTRY = 'N' UNION /******************************* * MFAR ADDITIONAL ENTRIES * *******************************/ SELECT /*+ INDEX(LI 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_ATTRIBUTE2 APP_GLOBAL_ATTR2
, 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_CATEGORY APP_GLOBAL_ATTR_CAT
, RAA.USSGL_TRANSACTION_CODE APP_USSGL_TRX_CODE
, RAA.USSGL_TRANSACTION_CODE_CONTEXT APP_USSGL_TRX_CODE_CT
, LI.EVENT_ID EVENT_ID
, 'C' XLA_PARTY_TYPE
, LI.CRH_STATUS APP_CRH_STATUS
, LI.LINE_NUMBER LINE_NUMBER
, LI.LANGUAGE LANGUAGE
, LI.LEDGER_ID LEDGER_ID
FROM AR_XLA_LINES_EXTRACT LI
, AR_RECEIVABLE_APPLICATIONS_ALL RAA
WHERE LI.EVENT_ID = RAA.EVENT_ID
AND LI.SOURCE_ID = RAA.RECEIVABLE_APPLICATION_ID
AND LI.SOURCE_TABLE = 'RA'
AND LI.LEVEL_FLAG = 'L'
AND LI.MFAR_ADDITIONAL_ENTRY = 'Y'