CJM_XLA_CUSTOMER_ACC_HDR_V
Details
-
Schema: FUSION
-
Object owner: CJM
-
Object type: VIEW
Columns
Name |
---|
EVENT_ID CUST_ACRL_THIRD_PARTY_TYPE CUSTOMER_ACCRUAL_ID CUST_ACRL_ACCR_TO_CUSTOMER_ID CUST_ACRL_TRX_BILL_TO_CUST_ID CUST_ACRL_TRX_BILTO_S_USE_ID CUST_ACRL_AMOUNT CUST_ACRL_CURRENCY CUST_ACRL_LEDGER_AMOUNT CUST_ACRL_DISTRIBUTION_TYPE CUST_ACRL_DISTRIBUTION_ID CUST_ACRL_BU_ID CUST_ACRL_ITEM_LEVEL_CODE CUST_ACRL_ITEM_ID CUST_ACRL_ITEM_NUMBER CUST_PROGRAM_HEADER_ID CUST_PROGRAM_LINE_ID CUST_PROMOTION_CODE CUST_PROGRAM_TYPE_ID CUST_PROGRAM_TEMPLATE_ID CUST_PROGRAM_TEMPLATE_NAME CUST_ACRL_TYPE CUST_ACRL_EXCHANGE_RATE CUST_ACRL_EXCHANGE_RATE_DATE CUST_ACRL_EXCHANGE_RATE_TYPE CUST_ACRL_GL_DATE CUST_ACRL_OBJECT_TYPE CUST_ACRL_OBJECT_ID CUST_ACRL_OBJECT_NUMBER CUST_ACRL_OBJECT_LINE_ID CUST_ACRL_REFERENCE_TYPE CUST_ACRL_REFERENCE_ID CUST_ACRL_ADJUSTMENT_TYPE_ID CUST_ACRL_ADJUSTMENT_TYPE CUST_ACNT_AMT_OVERRIDE_FLAG CUST_PGM_HRD_ATTRIB_CATGORY CUST_PGM_HDR_ATTRIB_1 CUST_PGM_HDR_ATTRIB_2 CUST_PGM_HDR_ATTRIB_3 CUST_PGM_HDR_ATTRIB_4 CUST_PGM_HDR_ATTRIB_5 CUST_PGM_HDR_ATTRIB_6 CUST_PGM_HDR_ATTRIB_7 CUST_PGM_HDR_ATTRIB_8 CUST_PGM_HDR_ATTRIB_9 CUST_PGM_HDR_ATTRIB_10 CUST_PGM_HDR_ATTRIB_11 CUST_PGM_HDR_ATTRIB_12 CUST_PGM_HDR_ATTRIB_13 CUST_PGM_HDR_ATTRIB_14 CUST_PGM_HDR_ATTRIB_15 CUST_PGM_HDR_ATTRIB_16 CUST_PGM_HDR_ATTRIB_17 CUST_PGM_HDR_ATTRIB_18 CUST_PGM_HDR_ATTRIB_19 CUST_PGM_HDR_ATTRIB_20 CUST_PGM_HDR_ATTRIB_NUM_1 CUST_PGM_HDR_ATTRIB_NUM_2 CUST_PGM_HDR_ATTRIB_NUM_3 CUST_PGM_HDR_ATTRIB_NUM_4 CUST_PGM_HDR_ATTRIB_NUM_5 CUST_PGM_HDR_ATTRIB_NUM_6 CUST_PGM_HDR_ATTRIB_NUM_7 CUST_PGM_HDR_ATTRIB_NUM_8 CUST_PGM_HDR_ATTRIB_NUM_9 CUST_PGM_HDR_ATTRIB_NUM_10 CUST_PGM_HDR_ATTRIB_DATE_1 CUST_PGM_HDR_ATTRIB_DATE_2 CUST_PGM_HDR_ATTRIB_DATE_3 CUST_PGM_HDR_ATTRIB_DATE_4 CUST_PGM_HDR_ATTRIB_DATE_5 |
Query
SQL_Statement |
---|
SELECT /*+ leading(XEG) use_nl(XEG cxa )*/ xeg.event_id event_id, 'C' cust_acrl_third_party_type, accr.customer_accrual_id customer_accrual_id, accr.cust_account_id cust_acrl_accr_to_customer_id, accr.trx_cust_account_id cust_acrl_trx_bill_to_cust_id, accr.trx_bill_to_site_use_id cust_acrl_trx_bilto_s_use_id, accr.transaction_curr_amount cust_acrl_amount, accr.transaction_currency_code cust_acrl_currency, accr.acctd_amount cust_acrl_ledger_amount, 'CUSTOMER_ACCRUAL' cust_acrl_distribution_type, accr.customer_accrual_id cust_acrl_distribution_id, accr.bu_id cust_acrl_bu_id, accr.item_level_code cust_acrl_item_level_code, accr.item_id cust_acrl_item_id, cjm_utility_pkg.get_item_name(accr.item_level_code, accr.item_id, accr.bu_id) cust_acrl_item_number, pgm_b.program_header_id cust_program_header_id, accr.program_line_id cust_program_line_id, pgm_b.program_code cust_promotion_code, pgmtyb.program_type_id cust_program_type_id, pgmtyb.PARENT_PROGRAM_TYPE_ID cust_program_template_id, cjm_utility_pkg.get_lookup_meaning('ORA_CJM_PROGRAM_TYPE', pgm_b.program_type_code) cust_program_template_name, accr.utilization_type cust_acrl_type, accr.exchange_rate cust_acrl_exchange_rate, accr.exchange_rate_date cust_acrl_exchange_rate_date, accr.exchange_rate_type cust_acrl_exchange_rate_type, accr.gl_date cust_acrl_gl_date, accr.object_type cust_acrl_object_type, accr.object_id cust_acrl_object_id, NULL cust_acrl_object_number, accr.object_line_id cust_acrl_object_line_id, accr.reference_type cust_acrl_reference_type, accr.reference_id cust_acrl_reference_id, accr.adjustment_type_id cust_acrl_adjustment_type_id, accr.adjustment_type cust_acrl_adjustment_type, 'Y' cust_acnt_amt_override_flag, pgm_b.attribute_category cust_pgm_hrd_attrib_catgory, pgm_b.attribute_char1 cust_pgm_hdr_attrib_1, pgm_b.attribute_char2 cust_pgm_hdr_attrib_2, pgm_b.attribute_char3 cust_pgm_hdr_attrib_3, pgm_b.attribute_char4 cust_pgm_hdr_attrib_4, pgm_b.attribute_char5 cust_pgm_hdr_attrib_5, pgm_b.attribute_char6 cust_pgm_hdr_attrib_6, pgm_b.attribute_char7 cust_pgm_hdr_attrib_7, pgm_b.attribute_char8 cust_pgm_hdr_attrib_8, pgm_b.attribute_char9 cust_pgm_hdr_attrib_9, pgm_b.attribute_char10 cust_pgm_hdr_attrib_10, pgm_b.attribute_char11 cust_pgm_hdr_attrib_11, pgm_b.attribute_char12 cust_pgm_hdr_attrib_12, pgm_b.attribute_char13 cust_pgm_hdr_attrib_13, pgm_b.attribute_char14 cust_pgm_hdr_attrib_14, pgm_b.attribute_char15 cust_pgm_hdr_attrib_15, pgm_b.attribute_char16 cust_pgm_hdr_attrib_16, pgm_b.attribute_char17 cust_pgm_hdr_attrib_17, pgm_b.attribute_char18 cust_pgm_hdr_attrib_18, pgm_b.attribute_char19 cust_pgm_hdr_attrib_19, pgm_b.attribute_char20 cust_pgm_hdr_attrib_20, pgm_b.attribute_number1 cust_pgm_hdr_attrib_num_1, pgm_b.attribute_number2 cust_pgm_hdr_attrib_num_2, pgm_b.attribute_number3 cust_pgm_hdr_attrib_num_3, pgm_b.attribute_number4 cust_pgm_hdr_attrib_num_4, pgm_b.attribute_number5 cust_pgm_hdr_attrib_num_5, pgm_b.attribute_number6 cust_pgm_hdr_attrib_num_6, pgm_b.attribute_number7 cust_pgm_hdr_attrib_num_7, pgm_b.attribute_number8 cust_pgm_hdr_attrib_num_8, pgm_b.attribute_number9 cust_pgm_hdr_attrib_num_9, pgm_b.attribute_number10 cust_pgm_hdr_attrib_num_10, pgm_b.attribute_date1 cust_pgm_hdr_attrib_date_1, pgm_b.attribute_date2 cust_pgm_hdr_attrib_date_2, pgm_b.attribute_date3 cust_pgm_hdr_attrib_date_3, pgm_b.attribute_date4 cust_pgm_hdr_attrib_date_4, pgm_b.attribute_date5 cust_pgm_hdr_attrib_date_5 FROM cjm_customer_accruals_all accr, cjm_xla_customer_accruals cxa, cjm_programs_all_b pgm_b, cjm_program_types_b pgmtyb, xla_events_gt xeg WHERE xeg.application_id = 10566 AND xeg.entity_code = 'CUSTOMER_ACCRUAL' AND accr.customer_accrual_id = cxa.customer_accrual_id AND accr.program_header_id = pgm_b.program_header_id AND xeg.source_id_int_1 = cxa.customer_accrual_id AND cxa.event_type_code = xeg.event_type_code AND pgmtyb.program_type_id = pgm_b.program_type_id |