PJC_XLA_LD_HEADER

Details

Name
EVENT_ID LD_TXN_ID ADJUSTED_ALLOC_TXN_ID PERSON_ID ASSIGNMENT_ID EXPENDITURE_ITEM_DATE APPLICATION_ID LD_DIST_TYPE LD_ENTITY_CODE PAY_ELEMENT_TYPE ACCOUNTING_DATE RUN_ID REPROCESS_FLAG

Name

EVENT_ID

LD_TXN_ID

ADJUSTED_ALLOC_TXN_ID

PERSON_ID

ASSIGNMENT_ID

EXPENDITURE_ITEM_DATE

APPLICATION_ID

LD_DIST_TYPE

LD_ENTITY_CODE

PAY_ELEMENT_TYPE

ACCOUNTING_DATE

RUN_ID

REPROCESS_FLAG

SQL_Statement
SELECT xev.event_id, ld.ld_txn_id, ld.adjusted_alloc_txn_id, ld.person_id, ld.assignment_id, ld.expenditure_item_date, to_number(10036) as APPLICATION_ID, 'LABOR_DISTRIBUTION' as LD_DIST_TYPE, 'PAYROLL_DISTRIBUTION' as LD_ENTITY_CODE, ld.LD_ELEMENT_TYPE_ID PAY_ELEMENT_TYPE, xev.EVENT_DATE as ACCOUNTING_DATE, ld.run_id, ld.reserved_attribute9 as reprocess_flag FROM xla_events_gt xev, pjc_labor_dist_txn_details ld where xev.application_id = 10036 and xev.source_id_int_1 = ld.ld_txn_id

SQL_Statement

SELECT

xev.event_id,

ld.ld_txn_id,

ld.adjusted_alloc_txn_id,

ld.person_id,

ld.assignment_id,

ld.expenditure_item_date,

to_number(10036) as APPLICATION_ID,

'LABOR_DISTRIBUTION' as LD_DIST_TYPE,

'PAYROLL_DISTRIBUTION' as LD_ENTITY_CODE,

ld.LD_ELEMENT_TYPE_ID PAY_ELEMENT_TYPE,

xev.EVENT_DATE as ACCOUNTING_DATE,

ld.run_id,

ld.reserved_attribute9 as reprocess_flag

FROM

xla_events_gt xev, pjc_labor_dist_txn_details ld

where xev.application_id = 10036 and xev.source_id_int_1 = ld.ld_txn_id