eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PJI_FP_XBS_ACCUM_F

Line 309: pji_fp_xbs_accum_f rl

305: , rl.CUSTOM14
306: , rl.CUSTOM15
307: , rl.PLAN_TYPE_CODE /* 4471527 */
308: FROM
309: pji_fp_xbs_accum_f rl
310: , pji_fm_extr_plnver3_t ver3
311: WHERE 1=1
312: AND rl.project_id = l_src_project_ids(i)
313: AND rl.plan_version_id = p_source_fp_version_ids(i)

Line 396: DELETE FROM PJI_FP_XBS_ACCUM_F

392:
393: END LOOP;
394:
395: FORALL i IN 1..p_dest_fp_version_ids.COUNT
396: DELETE FROM PJI_FP_XBS_ACCUM_F
397: WHERE plan_version_id = p_dest_fp_version_ids(i)
398: AND project_id = l_dest_project_ids(i);
399:
400: FORALL i IN 1..p_dest_fp_version_ids.COUNT

Line 557: pji_fp_xbs_accum_f rl

553: , rl.CUSTOM14
554: , rl.CUSTOM15
555: , rl.PLAN_TYPE_CODE /* 4471527 */
556: FROM
557: pji_fp_xbs_accum_f rl
558: WHERE 1=1
559: AND ( (rl.rbs_aggr_level = g_top_level) OR (rl.rbs_aggr_level = g_lowest_level AND wbs_rollup_flag = 'N' ))
560: AND rl.plan_version_id = p_source_fp_version_ids(i));
561:

Line 610: DELETE FROM PJI_FP_XBS_ACCUM_F

606: INTO l_dest_plan_type_id, l_dest_project_id
607: FROM pa_budget_versions
608: WHERE budget_version_id = p_target_plan_ver_id;
609:
610: DELETE FROM PJI_FP_XBS_ACCUM_F
611: WHERE plan_version_id = p_target_plan_ver_id
612: AND project_id = l_dest_project_id;
613:
614: DELETE FROM pji_rollup_level_status

Line 771: FROM pji_fp_xbs_accum_f rl

767: , rl.CUSTOM13
768: , rl.CUSTOM14
769: , rl.CUSTOM15
770: , rl.PLAN_TYPE_CODE /* 4471527 */
771: FROM pji_fp_xbs_accum_f rl
772: WHERE 1=1
773: AND rl.plan_version_id = p_source_plan_ver_id
774: AND ( (rl.rbs_aggr_level = g_top_level) OR (rl.rbs_aggr_level = g_lowest_level AND wbs_rollup_flag = 'N' ))
775: ) ;

Line 4131: pji_fp_xbs_accum_f fact

4127: , -fact.CUSTOM15
4128: , g_ntp_period_name
4129: , fact.plan_type_code /* 4471527 */
4130: FROM
4131: pji_fp_xbs_accum_f fact
4132: , pji_fm_extr_plnver3_t ver
4133: WHERE 1=1
4134: AND fact.plan_version_id = ver.plan_version_id
4135: AND fact.plan_type_code = ver.plan_type_code /* 4471527 */

Line 4366: pji_fp_xbs_accum_f rl

4362: , rl.CUSTOM15
4363: , g_default_prg_level
4364: , rl.PLAN_TYPE_CODE /* 4471527 */
4365: FROM
4366: pji_fp_xbs_accum_f rl
4367: , pa_budget_versions bv -- @pjdev115 bv
4368: , pa_proj_fp_options fpo -- @pjdev115 fpo
4369: WHERE
4370: rl.project_id = bv.project_id

Line 5691: FROM pji_fp_xbs_accum_f fact

5687: , null RATE_DANGLING_FLAG
5688: , null TIME_DANGLING_FLAG
5689: -- , 0 prg_level
5690: , fact.plan_type_code plan_type_code -- 4471527
5691: FROM pji_fp_xbs_accum_f fact
5692: , pji_fm_extr_plnver3_t ver3
5693: WHERE 1=1
5694: AND rbs_aggr_level = g_lowest_level
5695: AND wbs_rollup_flag = 'N'

Line 5896: FROM pji_fp_xbs_accum_f fact

5892: , NULL) rate_dangling_flag
5893: , null TIME_DANGLING_FLAG
5894: -- , 0 prg_level
5895: , fact.plan_type_code plan_type_code -- 4471527
5896: FROM pji_fp_xbs_accum_f fact
5897: , pa_projects_all ppa
5898: , ( SELECT g_global1_currency_code curr_code, 0.01 mau FROM DUAL
5899: UNION
5900: SELECT g_global2_currency_code curr_code, 0.01 mau FROM DUAL

Line 6108: FROM pji_fp_xbs_accum_f fact

6104: -- , START_DATE
6105: -- , END_DATE
6106: -- , 0
6107: , fact.plan_type_code plan_type_code -- 4471527
6108: FROM pji_fp_xbs_accum_f fact
6109: , pji_fm_extr_plnver3_t ver
6110: WHERE 1=1
6111: AND fact.project_id = ver.project_id
6112: AND fact.plan_version_id = ver.plan_version_id

Line 6160: UPDATE pji_fp_xbs_accum_f

6156: IS BEGIN
6157:
6158: print_time('........UPDATE_TPFG1_CURR_RCDS: Begin. ' );
6159:
6160: UPDATE pji_fp_xbs_accum_f
6161: SET CURR_RECORD_TYPE_ID = CURR_RECORD_TYPE_ID +
6162: DECODE (currency_code, g_global1_currency_code, 2, 0) -- 000.000.010 = 2
6163: + DECODE (currency_code, g_global2_currency_code, 1, 0) -- 000.000.001 = 1
6164: WHERE BITAND(curr_record_type_id, 28) >= 4 -- 000.011.110 = 16 + 8 + 4 = 28

Line 6570: SELECT /+ full(tmp) index(rl, PJI_FP_XBS_ACCUM_F_N1) use_nl(rl) /

6566: worker_id
6567: , pjp1_rowid
6568: , fpr_rowid
6569: )
6570: SELECT /*+ full(tmp) index(rl, PJI_FP_XBS_ACCUM_F_N1) use_nl(rl) */
6571: g_worker_id WORKER_ID
6572: , tmp.ROWID pjp1_rowid
6573: , rl.ROWID fpr_ROWID
6574: FROM

Line 6576: , pji_fp_xbs_accum_f rl

6572: , tmp.ROWID pjp1_rowid
6573: , rl.ROWID fpr_ROWID
6574: FROM
6575: pji_fp_aggr_pjp1_t tmp
6576: , pji_fp_xbs_accum_f rl
6577: WHERE 1 = 1
6578: AND tmp.WORKER_ID = g_worker_id
6579: AND tmp.PROJECT_ID = rl.PROJECT_ID (+)
6580: AND tmp.PLAN_VERSION_ID = rl.PLAN_VERSION_ID (+)

Line 7242: pji_fp_xbs_accum_f rl

7238:
7239: BEGIN
7240:
7241: UPDATE /*+ ordered use_nl(rl) rowid(rl) */
7242: pji_fp_xbs_accum_f rl
7243: SET (
7244: rl.RAW_COST
7245: , rl.BRDN_COST
7246: , rl.REVENUE

Line 7471: INSERT INTO pji_fp_xbs_accum_f fact

7467: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7468:
7469: BEGIN
7470:
7471: INSERT INTO pji_fp_xbs_accum_f fact
7472: (
7473: PROJECT_ID
7474: , PROJECT_ORG_ID
7475: , PROJECT_ORGANIZATION_ID

Line 8499: FROM pji_fp_xbs_accum_f

8495: , CUSTOM14
8496: , CUSTOM15
8497: , g_default_prg_level
8498: , plan_type_code
8499: FROM pji_fp_xbs_accum_f
8500: WHERE plan_version_id = p_pln_ver_id
8501: );
8502:
8503: EXCEPTION