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 823: from pji_pjp_proj_batch_map map,pa_projects_all pa

819: l_rpt_excep_reason varchar2(30);
820: l_rpt_footer varchar2(60);
821: cursor c_err_report is
822: select pa.segment1,map.act_err_msg
823: from pji_pjp_proj_batch_map map,pa_projects_all pa
824: where pa.project_id=map.project_id
825: and map.worker_id=p_worker_id
826: and map.act_err_msg is not null
827: order by segment1;

Line 897: from pji_pjp_proj_batch_map map,pa_projects_all pa

893: l_rpt_footer varchar2(60);
894:
895: cursor c_err_report is
896: select pa.segment1,pa.name
897: from pji_pjp_proj_batch_map map,pa_projects_all pa
898: where pa.project_id=map.project_id
899: and map.worker_id=p_worker_id
900: and map.act_err_msg is null
901: order by segment1;

Line 2310: PA_PROJECTS_ALL map,

2306: 'LF', 'N') WP_FLAG,
2307: 'Y' PUSHUP_FLAG
2308: from
2309: PJI_XBS_DENORM prg,
2310: PA_PROJECTS_ALL map,
2311: (
2312: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
2313: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
2314: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

Line 2833: from pa_projects_all

2829: IF p_from_project is not null
2830: or p_to_project is not null then
2831: select min(segment1) ,max(segment1)
2832: into l_from_project_num, l_to_project_num
2833: from pa_projects_all
2834: where segment1 between nvl(p_from_project,segment1) and nvl(p_to_project,segment1);
2835: END if;
2836: /* Get the Project Ids ,this is required to keep the impact minimum , these values will be updated in pji_system_parameters Table */
2837: IF l_from_project_num is not null and p_from_project is not null THEN

Line 2840: from pa_projects_all

2836: /* Get the Project Ids ,this is required to keep the impact minimum , these values will be updated in pji_system_parameters Table */
2837: IF l_from_project_num is not null and p_from_project is not null THEN
2838: select project_id
2839: into p_from_project_id
2840: from pa_projects_all
2841: where segment1= l_from_project_num;
2842: else
2843: p_from_project_id:=-1;
2844: END IF;

Line 2848: from pa_projects_all

2844: END IF;
2845: IF l_to_project_num is not null and p_to_project is not null THEN
2846: select project_id
2847: into p_to_project_id
2848: from pa_projects_all
2849: where segment1= l_to_project_num;
2850: else
2851: p_to_project_id:=-1;
2852: END IF;

Line 3176: PA_PROJECTS_ALL prj,

3172: decode(active_projects.PROJECT_STATUS_CODE,
3173: null, 'N', 'Y') PROJECT_ACTIVE_FLAG */
3174: from
3175: PJI_PJP_PROJ_EXTR_STATUS status,
3176: PA_PROJECTS_ALL prj,
3177: PA_PROJECT_STATUSES proj_status /*,
3178: ( Processing is not depending on Project status Bug 5057835
3179: select
3180: distinct

Line 3240: PA_PROJECTS_ALL prj ,

3236: prj.PROJECT_CURRENCY_CODE,
3237: 'Y' PROJECT_ACTIVE_FLAG
3238: from
3239: PJI_PJP_PROJ_EXTR_STATUS status,
3240: PA_PROJECTS_ALL prj ,
3241: PJI_PRG_GROUP prg1
3242: where
3243: status.PROJECT_ID = prj.PROJECT_ID and
3244: prj.project_id = prg1.project_id and

Line 3282: PA_PROJECTS_ALL prj,

3278: prj.PROJECT_CURRENCY_CODE,
3279: decode(active_projects.PROJECT_ID, null, 'N', 'Y') PROJECT_ACTIVE_FLAG
3280: from
3281: PJI_PJP_PROJ_EXTR_STATUS status,
3282: PA_PROJECTS_ALL prj,
3283: (
3284: select /*+ ordered
3285: index(prg, PA_XBS_DENORM_N3)
3286: distinct

Line 3290: PA_PROJECTS_ALL prj,

3286: distinct
3287: emt.PROJECT_ID
3288: from
3289: PA_PROJECT_STATUSES stat,
3290: PA_PROJECTS_ALL prj,
3291: PA_XBS_DENORM prg,
3292: PA_PROJ_ELEMENTS emt
3293: where
3294: stat.STATUS_TYPE = 'PROJECT' and

Line 3404: PA_PROJECTS_ALL prj

3400: prg2.PRG_GROUP = prg1.PRG_GROUP
3401: ) map,
3402: PJI_PJP_PROJ_BATCH_MAP existing_projects,
3403: PJI_PJP_PROJ_EXTR_STATUS status,
3404: PA_PROJECTS_ALL prj
3405: where
3406: p_worker_id = existing_projects.WORKER_ID (+) and
3407: map.PROJECT_ID = existing_projects.PROJECT_ID (+) and
3408: existing_projects.PROJECT_ID is null and

Line 3480: PA_PROJECTS_ALL prj,

3476: null, 'N', 'Y') PROJECT_ACTIVE_FLAG */
3477: from
3478: PA_PJI_PROJ_EVENTS_LOG log,
3479: PA_RBS_PRJ_ASSIGNMENTS rbs_asg,
3480: PA_PROJECTS_ALL prj,
3481: PA_PROJECT_TYPES_ALL pt /*,
3482: ( Processing is now not depending on status Bug 5057835
3483: select /*+ ordered
3484: index(prg, PA_XBS_DENORM_N3)

Line 3489: PA_PROJECTS_ALL prj,

3485: distinct
3486: emt.PROJECT_ID
3487: from
3488: PA_PROJECT_STATUSES stat,
3489: PA_PROJECTS_ALL prj,
3490: PA_XBS_DENORM prg,
3491: PA_PROJ_ELEMENTS emt
3492: where
3493: stat.STATUS_TYPE = 'PROJECT' and

Line 3554: PA_PROJECTS_ALL prj,

3550: /* decode(active_projects.PROJECT_ID,
3551: null, 'N', 'Y') PROJECT_ACTIVE_FLAG */
3552: from
3553: PA_PJI_PROJ_EVENTS_LOG log,
3554: PA_PROJECTS_ALL prj,
3555: PA_PROJECT_TYPES_ALL pt
3556: where
3557: log.EVENT_TYPE in ('RBS_PUSH', 'RBS_DELETE') and
3558: prj.cbs_version_id = log.attribute2 and

Line 4086: l_from_project pa_projects_all.segment1%TYPE;

4082: l_plan_type_id number;
4083: l_rbs_header_id number;
4084: l_only_pt_projects_flag varchar2(255);
4085: l_operating_unit number;
4086: l_from_project pa_projects_all.segment1%TYPE;
4087: l_to_project pa_projects_all.segment1%TYPE;
4088: l_project_status varchar2(30); --12.1.3 enhancement
4089:
4090: begin

Line 4087: l_to_project pa_projects_all.segment1%TYPE;

4083: l_rbs_header_id number;
4084: l_only_pt_projects_flag varchar2(255);
4085: l_operating_unit number;
4086: l_from_project pa_projects_all.segment1%TYPE;
4087: l_to_project pa_projects_all.segment1%TYPE;
4088: l_project_status varchar2(30); --12.1.3 enhancement
4089:
4090: begin
4091: