PJC_XLA_EXP_BU_REF_V

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name
EXPENDITURE_OU_ID EXPENDITURE_BU_NAME EXP_BU_COMPANY EXP_BU_COST_CENTER

Query

SQL_Statement
SELECT hroi.organization_id Expenditure_OU_ID, hroi.organization_id expenditure_bu_name, pjc_accounting_pvt.get_company_info(hroi.organization_id) exp_bu_company, pjc_accounting_pvt.get_costcenter_info(hroi.organization_id) exp_bu_cost_center FROM hr_all_organization_units_f hroi WHERE trunc(sysdate) between hroi.effective_start_date and hroi.effective_end_date