PJC_XLA_CCDL_LINES_ADJ_V

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name

APPLICATION_ID EVENT_ID EXPENDITURE_ITEM_ID LINE_NUMBER CCDL_LINE_NUMBER LEDGER_ID LINE_TYPE CC_DIST_LINE_ID DIST_LINE_ID_REVERSED REVERSING_LINE_FLAG CROSS_CHARGE_CODE PCCDL_REFERENCE_1 PCCDL_REFERENCE_2 PCCDL_REFERENCE_3 ENTERED_CURRENCY_CODE LINE_NUM_REVERSED ENTERED_AMOUNT ACCT_AMOUNT EXCHANGE_RATE EXCHANGE_RATE_DATE EXCHANGE_RATE_TYPE IMPORTED_RAW_DR_ACCOUNT_CCID IMPORTED_RAW_CR_ACCOUNT_CCID PROJECT_ACCOUNTING_DATE ACCOUNTING_PERIOD PROJECT_ACCOUNTING_PERIOD RAW_SOURCE_DIST_ID_NUM_1 RAW_SOURCE_DIST_ID_NUM_2 RAW_SOURCE_DIST_TYPE RAW_APPLICATION_ID RAW_LEDGER_ID EXP_CCDL_CREATION_DATE EXP_CCDL_CREATED_BY EXP_CCDL_LAST_UPDATED_DATE EXP_CCDL_LAST_UPDATED_BY

Query

SQL_Statement

SELECT 10036 application_id, ccdl.acct_event_id event_id, ccdl.expenditure_item_id expenditure_item_id, ccdl.line_num line_number, ccdl.line_num ccdl_line_number, to_number(imp.ledger_id) ledger_id, ccdl.line_type line_type, ccdl.cc_dist_line_id, ccdl.dist_line_id_reversed, DECODE(ccdl.dist_line_id_reversed, NULL, 'N', DECODE(ccdl_orig.expenditure_item_id, ccdl.expenditure_item_id, 'Y', 'N')) reversing_line_flag, ccdl.cross_charge_code cross_charge_code, ccdl.reference_1 pccdl_reference_1, ccdl.reference_2 pccdl_reference_2, ccdl.reference_3 pccdl_reference_3, ccdl.denom_tp_currency_code entered_currency_code, DECODE(NVL(CCDL.Acct_source_Code, 'UPG'), 'PA', DECODE(ccdl_orig.expenditure_item_id, ccdl.expenditure_item_id,CCDL_ORIG.LINE_NUM), NULL) line_num_reversed, ccdl.denom_transfer_price entered_amount, ccdl.amount acct_amount, ccdl.acct_tp_exchange_rate exchange_rate, ccdl.acct_tp_rate_date exchange_rate_date, ccdl.acct_tp_rate_type exchange_rate_type, to_number(null) IMPORTED_RAW_DR_ACCOUNT_CCID, to_number(null) IMPORTED_RAW_CR_ACCOUNT_CCID, ccdl.pa_date project_accounting_date, ccdl.gl_period_name accounting_period, ccdl.pa_period_name project_accounting_period, /* Following attributes are required to derive the account from SLA using reference view */ ccdl_orig.Expenditure_Item_id raw_source_dist_id_num_1, ccdl_orig.Line_Num raw_source_dist_id_num_2, ccdl_orig.Line_Type raw_source_dist_type, 10036 raw_application_id, to_number(imp.ledger_id) raw_ledger_id, trunc(ccdl.CREATION_DATE) EXP_CCDL_CREATION_DATE, ccdl.CREATED_BY EXP_CCDL_CREATED_BY, trunc(ccdl.LAST_UPDATE_DATE) EXP_CCDL_LAST_UPDATED_DATE, ccdl.LAST_UPDATED_BY EXP_CCDL_LAST_UPDATED_BY FROM pjc_cc_dist_lines_all ccdl, pjc_cc_dist_lines_all ccdl_orig , XLA_EVENTS_GT imp WHERE ccdl_orig.cc_dist_line_id(+) = ccdl.dist_line_id_reversed AND imp.event_id = ccdl.acct_event_id AND imp.source_id_int_1 = ccdl.expenditure_item_id