DBA Data[Home] [Help]

APPS.PA_PPR_ROLLUP_PVT dependencies on PJI_FM_EXTR_PLAN_LINES

Line 525: PJI_FM_EXTR_PLAN_LINES bl2,

521: nvl(b.connect_path , '/'||DECODE(bl2.project_element_id, 0, l_struct_elem_id, bl2.project_element_id) ) connect_path,
522: nvl(b.leaf_node,1) leaf_node,
523: nvl(b.wbs_rbs_level,1) task_level_arr
524: FROM
525: PJI_FM_EXTR_PLAN_LINES bl2,
526: pa_ppr_obj_tmp b
527: WHERE
528: bl2.plan_version_id = l_budget_version_id
529: and bl2.project_element_id = b.object_id ) t1

Line 593: PJI_FM_EXTR_PLAN_LINES bl

589: , bl.quantity quantity
590: , bl.act_quantity act_quantity
591: , bl.etc_quantity etc_quantity
592: FROM
593: PJI_FM_EXTR_PLAN_LINES bl
594: WHERE 1=1
595: AND bl.project_id = l_project_id
596: AND bl.plan_version_id = l_budget_version_id
597: ) t , pa_ppr_obj_tmp b

Line 665: PJI_FM_EXTR_PLAN_LINES bl

661: , bl.etc_quantity etc_quantity
662: , bl.rbs_element_id
663: , bl.cbs_element_id
664: FROM
665: PJI_FM_EXTR_PLAN_LINES bl
666: WHERE 1=1
667: AND bl.project_id = l_project_id
668: AND bl.plan_version_id = l_budget_version_id
669: ) t , pa_ppr_obj_tmp b

Line 929: PJI_FM_EXTR_PLAN_LINES bl

925: , bl.quantity quantity
926: , TO_NUMBER(NULL) act_quantity
927: , NVL(bl.quantity, 0)+NVL(bl.etc_quantity, 0) etc_quantity
928: FROM
929: PJI_FM_EXTR_PLAN_LINES bl
930: WHERE 1=1
931: AND bl.project_id = l_project_id
932: AND bl.plan_version_id = l_budget_version_id
933: UNION ALL