1. Tables and Views for SCM
  2. CJM_XLA_CUSTOMER_ACC_HDR_V

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