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_PJP_SUM_MAIN dependencies on PA_PROJECTS_ALL

Line 800: from pji_pjp_proj_batch_map map,pa_projects_all pa

796: l_rpt_excep_reason varchar2(30);
797: l_rpt_footer varchar2(60);
798: cursor c_err_report is
799: select pa.segment1,map.act_err_msg
800: from pji_pjp_proj_batch_map map,pa_projects_all pa
801: where pa.project_id=map.project_id
802: and map.worker_id=p_worker_id
803: and map.act_err_msg is not null
804: order by segment1;

Line 874: from pji_pjp_proj_batch_map map,pa_projects_all pa

870: l_rpt_footer varchar2(60);
871:
872: cursor c_err_report is
873: select pa.segment1,pa.name
874: from pji_pjp_proj_batch_map map,pa_projects_all pa
875: where pa.project_id=map.project_id
876: and map.worker_id=p_worker_id
877: and map.act_err_msg is null
878: order by segment1;

Line 2287: PA_PROJECTS_ALL map,

2283: 'LF', 'N') WP_FLAG,
2284: 'Y' PUSHUP_FLAG
2285: from
2286: PJI_XBS_DENORM prg,
2287: PA_PROJECTS_ALL map,
2288: (
2289: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
2290: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
2291: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

Line 2802: from pa_projects_all

2798: IF p_from_project is not null
2799: or p_to_project is not null then
2800: select min(segment1) ,max(segment1)
2801: into l_from_project_num, l_to_project_num
2802: from pa_projects_all
2803: where segment1 between nvl(p_from_project,segment1) and nvl(p_to_project,segment1);
2804: END if;
2805: /* Get the Project Ids ,this is required to keep the impact minimum , these values will be updated in pji_system_parameters Table */
2806: IF l_from_project_num is not null and p_from_project is not null THEN

Line 2809: from pa_projects_all

2805: /* Get the Project Ids ,this is required to keep the impact minimum , these values will be updated in pji_system_parameters Table */
2806: IF l_from_project_num is not null and p_from_project is not null THEN
2807: select project_id
2808: into p_from_project_id
2809: from pa_projects_all
2810: where segment1= l_from_project_num;
2811: else
2812: p_from_project_id:=-1;
2813: END IF;

Line 2817: from pa_projects_all

2813: END IF;
2814: IF l_to_project_num is not null and p_to_project is not null THEN
2815: select project_id
2816: into p_to_project_id
2817: from pa_projects_all
2818: where segment1= l_to_project_num;
2819: else
2820: p_to_project_id:=-1;
2821: END IF;

Line 3087: PA_PROJECTS_ALL prj /*,

3083: decode(active_projects.PROJECT_STATUS_CODE,
3084: null, 'N', 'Y') PROJECT_ACTIVE_FLAG */
3085: from
3086: PJI_PJP_PROJ_EXTR_STATUS status,
3087: PA_PROJECTS_ALL prj /*,
3088: ( Processing is not depending on Project status Bug 5057835
3089: select
3090: distinct
3091: stat.PROJECT_STATUS_CODE

Line 3142: PA_PROJECTS_ALL prj,

3138: prj.PROJECT_CURRENCY_CODE,
3139: decode(active_projects.PROJECT_ID, null, 'N', 'Y') PROJECT_ACTIVE_FLAG
3140: from
3141: PJI_PJP_PROJ_EXTR_STATUS status,
3142: PA_PROJECTS_ALL prj,
3143: (
3144: select /*+ ordered
3145: index(prg, PA_XBS_DENORM_N3)
3146: distinct

Line 3150: PA_PROJECTS_ALL prj,

3146: distinct
3147: emt.PROJECT_ID
3148: from
3149: PA_PROJECT_STATUSES stat,
3150: PA_PROJECTS_ALL prj,
3151: PA_XBS_DENORM prg,
3152: PA_PROJ_ELEMENTS emt
3153: where
3154: stat.STATUS_TYPE = 'PROJECT' and

Line 3261: PA_PROJECTS_ALL prj

3257: prg2.PRG_GROUP = prg1.PRG_GROUP
3258: ) map,
3259: PJI_PJP_PROJ_BATCH_MAP existing_projects,
3260: PJI_PJP_PROJ_EXTR_STATUS status,
3261: PA_PROJECTS_ALL prj
3262: where
3263: p_worker_id = existing_projects.WORKER_ID (+) and
3264: map.PROJECT_ID = existing_projects.PROJECT_ID (+) and
3265: existing_projects.PROJECT_ID is null and

Line 3336: PA_PROJECTS_ALL prj,

3332: null, 'N', 'Y') PROJECT_ACTIVE_FLAG */
3333: from
3334: PA_PJI_PROJ_EVENTS_LOG log,
3335: PA_RBS_PRJ_ASSIGNMENTS rbs_asg,
3336: PA_PROJECTS_ALL prj,
3337: PA_PROJECT_TYPES_ALL pt /*,
3338: ( Processing is now not depending on status Bug 5057835
3339: select /*+ ordered
3340: index(prg, PA_XBS_DENORM_N3)

Line 3345: PA_PROJECTS_ALL prj,

3341: distinct
3342: emt.PROJECT_ID
3343: from
3344: PA_PROJECT_STATUSES stat,
3345: PA_PROJECTS_ALL prj,
3346: PA_XBS_DENORM prg,
3347: PA_PROJ_ELEMENTS emt
3348: where
3349: stat.STATUS_TYPE = 'PROJECT' and

Line 3858: l_from_project pa_projects_all.segment1%TYPE;

3854: l_plan_type_id number;
3855: l_rbs_header_id number;
3856: l_only_pt_projects_flag varchar2(255);
3857: l_operating_unit number;
3858: l_from_project pa_projects_all.segment1%TYPE;
3859: l_to_project pa_projects_all.segment1%TYPE;
3860:
3861: begin
3862:

Line 3859: l_to_project pa_projects_all.segment1%TYPE;

3855: l_rbs_header_id number;
3856: l_only_pt_projects_flag varchar2(255);
3857: l_operating_unit number;
3858: l_from_project pa_projects_all.segment1%TYPE;
3859: l_to_project pa_projects_all.segment1%TYPE;
3860:
3861: begin
3862:
3863: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;