DBA Data[Home] [Help]

APPS.PJI_PMV_COST dependencies on PA_PROJECTS_ALL

Line 3357: , pa_projects_all prj

3353: FROM
3354: pji_project_classes PJM
3355: , pji_pmv_cls_dim_tmp PTM
3356: , pji_pmv_orgz_dim_tmp org
3357: , pa_projects_all prj
3358: WHERE
3359: pjm.project_class_id = ptm.id
3360: AND prj.project_id = pjm.project_id
3361: AND prj.carrying_out_organization_id = org.ID;

Line 3379: , pa_projects_all prj

3375: FROM pji_project_classes
3376: WHERE class_category = '$PROJECT_TYPE$CONTRACT') PJC
3377: , pji_pmv_cls_dim_tmp PTM
3378: , pji_pmv_orgz_dim_tmp org
3379: , pa_projects_all prj
3380: WHERE 1=1
3381: AND pjm.project_class_id = ptm.id
3382: AND prj.project_id = pjc.project_id
3383: AND prj.project_id = pjm.project_id

Line 3391: , pa_projects_all prj

3387: SELECT DISTINCT prj.project_id, '-1' name
3388: FROM
3389: pji_project_classes PJM
3390: , pji_pmv_orgz_dim_tmp org
3391: , pa_projects_all prj
3392: WHERE
3393: prj.project_id = pjm.project_id
3394: AND prj.carrying_out_organization_id = org.ID
3395: AND pjm.class_category = '$PROJECT_TYPE$CONTRACT';

Line 3883: FROM PA_PROJECTS_ALL

3879: , PROJECT_TYPE
3880: INTO l_detail_tab(i).PROJECT_NAME
3881: , l_detail_tab(i).PROJECT_NUMBER
3882: , l_detail_tab(i).PROJECT_TYPE
3883: FROM PA_PROJECTS_ALL
3884: WHERE PROJECT_ID = l_detail_tab(i).PROJECT_ID;
3885:
3886:
3887: /*