FLA_XLA_PAYMENT_PROJECTS_REF_V

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name
PROJECT_LEASE_DETAIL_ID PROJECT_PAYMENT_NUMBER PJC_PROJECT_ID PJC_TASK_ID PJC_EXPENDITURE_TYPE_ID PJC_ORGANIZATION_ID PJC_PROJECT_NUMBER PJC_TASK_NUMBER PJC_EXPENDITURE_TYPE_NAME PJC_ORGANIZATION_NAME

Query

SQL_Statement

SELECT ph.lease_detail_id project_lease_detail_id, ph.payment_number project_payment_number, ph.pjc_project_id pjc_project_id, ph.pjc_task_id pjc_task_id, ph.pjc_expenditure_type_id pjc_expenditure_type_id, ph.pjc_organization_id pjc_organization_id, p.segment1 pjc_project_number, t.element_number pjc_task_number, e.expenditure_type_name pjc_expenditure_type_name, o.name pjc_organization_name FROM fla_lease_payment_headers ph, pjf_projects_all_b p, pjf_proj_elements_b t, pjf_exp_types_vl e, hr_all_organization_units_f_vl o WHERE ph.pjc_project_id = p.project_id AND ph.pjc_task_id = t.proj_element_id AND ph.pjc_expenditure_type_id = e.expenditure_type_id AND ph.pjc_organization_id = o.organization_id