CJM_XLA_CUSTOMER_ACCRUAL_V

Details

• Schema: FUSION

• Object owner: CJM

• Object type: VIEW

Columns

Name
CUSTOMER_ACCRUAL_ID CUSTOMER_NAME CUSTOMER_BILL_TO PROGRAM_TYPE_TEMPLATE_NAME PROGRAM_TYPE_NAME PROGRAM_NAME PROMOTION_CODE ITEM_NUMBER ACCRUAL_TYPE ACCRUAL_DATE ACCRUAL_AMOUNT ACCRUAL_CURRENCY_CODE

Query

SQL_Statement

SELECT accr.customer_accrual_id customer_accrual_id, hzp.party_name customer_name, hzsu.location customer_bill_to, cjm_utility_pkg.get_lookup_meaning('ORA_CJM_PROGRAM_TYPE', pgm.program_type_code) program_type_template_name, prgtytl.program_type_name program_type_name, pgmtl.name program_name, pgm.program_code promotion_code, cjm_utility_pkg.get_item_name(accr.item_level_code, accr.item_id, accr.bu_id) item_number, accr.utilization_type accrual_type, accr.accrual_date accrual_date, accr.program_amount accrual_amount, accr.program_currency_code accrual_currency_code FROM cjm_xla_customer_accruals cxa, cjm_customer_accruals_all accr, cjm_programs_all_b pgm, cjm_programs_all_tl pgmtl, cjm_program_types_tl prgtytl, hz_parties hzp, hz_cust_accounts hzca, hz_cust_site_uses_all hzsu WHERE accr.customer_accrual_id = cxa.customer_accrual_id AND accr.program_header_id = pgm.program_header_id AND accr.cust_account_id = hzca.cust_account_id AND pgmtl.program_header_id = pgm.program_header_id AND pgmtl.language = userenv('LANG') AND prgtytl.program_type_id = accr.program_type_id AND prgtytl.language = userenv('LANG') AND hzca.party_id = hzp.party_id AND accr.bill_to_site_use_id = hzsu.site_use_id (+)