CJM_XLA_CUSTOMER_ACC_HDR

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_VAL_ORG_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

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_VAL_ORG_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, accr.inventory_organization_id cust_acrl_item_val_org_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

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,

accr.inventory_organization_id cust_acrl_item_val_org_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