PJO_DIS_PD_CURRENCY_ALL_V

Details

• Schema: FUSION

• Object owner: PJO

• Object type: VIEW

Columns

Name

PLANNING_ELEMENT_ID TXN_CURRENCY_CODE START_DATE END_DATE PERIOD_PROFILE_ID SESSION_ID PC_CODE PFC_CODE PFC_COST_RATE_TYPE PFC_COST_EXCHANGE_RATE PFC_COST_RATE_DATE_TYPE PFC_COST_RATE_DATE PFC_REV_RATE_TYPE PFC_REV_EXCHANGE_RATE PFC_REV_RATE_DATE_TYPE PFC_REV_RATE_DATE PC_COST_RATE_TYPE PC_COST_EXCHANGE_RATE PC_COST_RATE_DATE PC_COST_RATE_DATE_TYPE PC_REV_EXCHANGE_RATE PC_REV_RATE_DATE PC_REV_RATE_DATE_TYPE PC_REV_RATE_TYPE

Query

SQL_Statement

select ppe.planning_element_id, ppe.TXN_CURRENCY_CODE, ppe.start_date, ppe.end_date, ppe.period_profile_id, ppe.session_id, ppld.PC_CODE, ppld.PFC_CODE, ppld.PFC_COST_RATE_TYPE, ppld.PFC_COST_EXCHANGE_RATE, ppld.PFC_COST_RATE_DATE_TYPE, ppld.PFC_COST_RATE_DATE, ppld.PFC_REV_RATE_TYPE, ppld.PFC_REV_EXCHANGE_RATE, ppld.PFC_REV_RATE_DATE_TYPE, ppld.PFC_REV_RATE_DATE, ppld.PC_COST_RATE_TYPE, ppld.PC_COST_EXCHANGE_RATE, ppld.PC_COST_RATE_DATE, ppld.PC_COST_RATE_DATE_TYPE, ppld.PC_REV_EXCHANGE_RATE, ppld.PC_REV_RATE_DATE, ppld.PC_REV_RATE_DATE_TYPE, ppld.PC_REV_RATE_TYPE from pjo_plan_line_details ppld, pjo_dis_pd_period_v ppe WHERE ppld.plan_version_id(+) = ppe.plan_version_id and ppld.planning_element_id(+) = ppe.planning_element_id and ppld.TXN_CURRENCY_CODE(+) = ppe.TXN_CURRENCY_CODE and ppld.start_date(+) = ppe.start_date