DBA Data[Home] [Help]

APPS.PJI_FM_XBS_ACCUM_UTILS dependencies on PA_PJT_WBS_FACT

Line 2842: pa_pjt_wbs_fact fact

2838: decode (p1.projfunc_currency_code , fact.currency_code,1,0) POU_MASK
2839: from
2840: pa_projects_all p1 ,
2841: pa_ppr_obj_tmp_view obj1,
2842: pa_pjt_wbs_fact fact
2843: where 1 = 1
2844: AND p1.project_id = p_project_id
2845: AND fact.project_id = p_project_id
2846: and fact.PLAN_VERSION_ID in (l_plan_ver_id,l_lpb_plan_ver_id,l_base_plan_ver_id)

Line 3465: from pji_plan_extr_tmp tmp, pa_pjt_wbs_fact fact, pa_projects_all p

3461: sum(decode(p.project_currency_code,
3462: fact.currency_code, decode(fact.plan_version_id, WK_PLAN_VER_ID, fact.ETC_labor_raw_cost, 0 ))) P_ETC_LBR_RAW_COST,
3463: sum(decode(p.project_currency_code,
3464: fact.currency_code,decode(fact.plan_version_id, WK_PLAN_VER_ID, fact.ETC_equip_raw_cost, 0 ))) P_ETC_EQP_RAW_COST
3465: from pji_plan_extr_tmp tmp, pa_pjt_wbs_fact fact, pa_projects_all p
3466: where -1*tmp.project_id = fact.project_id
3467: and tmp.WK_PLAN_VER_ID = fact.plan_version_id
3468: and p.project_id = fact.project_id
3469: and fact.wbs_rollup_flag = 'Y'