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_XBS_ACCUM_MAINT dependencies on PJI_FM_EXTR_PLNVER3_T

Line 1053: WHERE plan_version_id IN (SELECT plan_version_id FROM pji_fm_extr_plnver3_t);

1049:
1050: IF (p_online_flag = 'Y') THEN
1051:
1052: /* DELETE FROM pji_rollup_level_status
1053: WHERE plan_version_id IN (SELECT plan_version_id FROM pji_fm_extr_plnver3_t);
1054: Bug No .4538102*/
1055:
1056: DELETE FROM pji_rollup_level_status
1057: WHERE (project_id,plan_version_id,plan_type_code) IN

Line 1058: (SELECT project_id,plan_version_id,plan_type_code FROM pji_fm_extr_plnver3_t); /4771527 /

1054: Bug No .4538102*/
1055:
1056: DELETE FROM pji_rollup_level_status
1057: WHERE (project_id,plan_version_id,plan_type_code) IN
1058: (SELECT project_id,plan_version_id,plan_type_code FROM pji_fm_extr_plnver3_t); /*4771527 */
1059:
1060: IF (SQL%ROWCOUNT > 0) THEN
1061:
1062: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_FM_EXTR_PLNVER3_T', 1 , 1 , 100);

Line 1062: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_FM_EXTR_PLNVER3_T', 1 , 1 , 100);

1058: (SELECT project_id,plan_version_id,plan_type_code FROM pji_fm_extr_plnver3_t); /*4771527 */
1059:
1060: IF (SQL%ROWCOUNT > 0) THEN
1061:
1062: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_FM_EXTR_PLNVER3_T', 1 , 1 , 100);
1063:
1064: /*
1065: FND_STATS.SET_TABLE_STATS(
1066: ownname => 'PJI', -- IN VARCHAR2,

Line 1067: tabname => 'PJI_FM_EXTR_PLNVER3_T', -- IN VARCHAR2,

1063:
1064: /*
1065: FND_STATS.SET_TABLE_STATS(
1066: ownname => 'PJI', -- IN VARCHAR2,
1067: tabname => 'PJI_FM_EXTR_PLNVER3_T', -- IN VARCHAR2,
1068: numrows => 1, -- IN NUMBER,
1069: numblks => 1, -- IN NUMBER,
1070: avgrlen => 100 --, -- IN NUMBER,
1071: );

Line 1076: (SELECT project_id, plan_version_id,plan_type_code FROM pji_fm_extr_plnver3_t)

1072: */
1073:
1074: DELETE FROM pji_fp_xbs_accum_f
1075: WHERE (project_id,plan_version_id,plan_type_code) IN /*4771527 */
1076: (SELECT project_id, plan_version_id,plan_type_code FROM pji_fm_extr_plnver3_t)
1077: AND (rbs_aggr_level = 'R'
1078: OR (rbs_aggr_level = 'L'
1079: AND wbs_rollup_flag = 'Y')) ;
1080: g_smart_rows_deleted := SQL%ROWCOUNT;

Line 3167: INSERT INTO PJI_FM_EXTR_PLNVER3_T ver3

3163: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(l_baseline_fp_ver_id, 'SECRBS');
3164: print_time(' Populated ver3. ');
3165:
3166:
3167: INSERT INTO PJI_FM_EXTR_PLNVER3_T ver3
3168: (
3169: PROJECT_ID ,
3170: PLAN_VERSION_ID ,
3171: WBS_STRUCT_VERSION_ID ,

Line 3205: FROM pji_fm_extr_plnver3_T bv

3201: , DECODE(cbco.plan_version_id, -4, 'Y', 'N') -- curr_original flag
3202: , 'Y' -- baselined flag.
3203: , bv.SECONDARY_RBS_FLAG
3204: , bv.lp_flag
3205: FROM pji_fm_extr_plnver3_T bv
3206: , pji_xbs_denorm den
3207: , ( SELECT -3 plan_version_id FROM DUAL
3208: UNION ALL
3209: SELECT -4 FROM DUAL ) cbco

Line 3220: DELETE FROM pji_fm_extr_plnver3_t

3216: AND den.sub_id = bv.wbs_struct_version_id
3217: AND NVL(den.relationship_type, 'WF') IN ('LF', 'WF') -- Excluding 'LW'
3218: ;
3219:
3220: DELETE FROM pji_fm_extr_plnver3_t
3221: WHERE plan_version_id > 0;
3222: print_time(' Need only -3, -4 records, deleted other plan version. ');
3223:
3224:

Line 7017: DELETE FROM PJI_FM_EXTR_PLNVER3_T;

7013: ( p_package_name => g_package_name
7014: , x_return_status => l_return_status );
7015:
7016: DELETE FROM pji_fp_aggr_pjp1_t;
7017: DELETE FROM PJI_FM_EXTR_PLNVER3_T;
7018: DELETE FROM pji_fp_rmap_fpr_update_t;
7019: EXCEPTION
7020: WHEN OTHERS THEN
7021: Pji_Pjp_Fp_Curr_Wrap.EXCP_HANDLER