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_PVT dependencies on PJI_RBS_DENORM

Line 985: DELETE FROM pji_rbs_denorm

981: AND plan_version_id > 0;
982:
983: print_time ( ' Number of records in rbs hdr tbl that were deleted is.. = ' || SQL%ROWCOUNT );
984:
985: DELETE FROM pji_rbs_denorm
986: WHERE struct_version_id = p_rbs_version_id; --Modified for Bug#6884573 by VVJOSHI
987:
988: print_time ( ' Number of rows in pji rbs denorm tbl that were deleted is.. = ' || SQL%ROWCOUNT );
989:

Line 988: print_time ( ' Number of rows in pji rbs denorm tbl that were deleted is.. = ' || SQL%ROWCOUNT );

984:
985: DELETE FROM pji_rbs_denorm
986: WHERE struct_version_id = p_rbs_version_id; --Modified for Bug#6884573 by VVJOSHI
987:
988: print_time ( ' Number of rows in pji rbs denorm tbl that were deleted is.. = ' || SQL%ROWCOUNT );
989:
990: DELETE FROM pa_rbs_denorm
991: WHERE struct_version_id = p_rbs_version_id; --Modified for Bug#6884573 by VVJOSHI
992:

Line 8128: , Pji_RBS_DENORM rbs

8124: , fact1.line_type
8125: , g_default_prg_level
8126: ,fact1.PLAN_TYPE_CODE /*4471527 */
8127: FROM pji_fp_aggr_pjp1 fact1
8128: , Pji_RBS_DENORM rbs
8129: , pji_rollup_level_status smart
8130: , pji_pjp_rbs_header rhdr
8131: WHERE 1 = 1
8132: AND fact1.project_id = rhdr.project_id