PJC_XLA_LD_LINE_V

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name
LD_TXN_ID LINE_NUMBER ENTERED_CURRENCY_CODE ENTERED_AMOUNT LD_COST_ACCOUNT_CCID EVENT_ID EXCHANGE_RATE EXCHANGE_RATE_DATE EXCHANGE_RATE_TYPE

Query

SQL_Statement
SELECT ld.ld_txn_id, 1 as LINE_NUMBER, ld.currency_code as ENTERED_CURRENCY_CODE, ld.total_allocation as ENTERED_AMOUNT, ld.target_ccid as LD_COST_ACCOUNT_CCID, ld.acct_event_id as EVENT_ID, to_number(null) as EXCHANGE_RATE, to_date(null) as EXCHANGE_RATE_DATE, null as EXCHANGE_RATE_TYPE FROM pjc_labor_dist_txn_details ld