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_XBS_DENORM

Line 2363: index(prg PJI_XBS_DENORM_N1) */

2359: (sup_wbs_hdr.PROJECT_ID,
2360: sup_wbs_hdr.WBS_VERSION_ID) in
2361: (
2362: select /*+ ordered
2363: index(prg PJI_XBS_DENORM_N1) */
2364: prg.SUP_PROJECT_ID,
2365: prg.SUP_ID
2366: from
2367: PJI_PJP_WBS_HEADER sub_wbs_hdr,

Line 2369: PJI_XBS_DENORM prg

2365: prg.SUP_ID
2366: from
2367: PJI_PJP_WBS_HEADER sub_wbs_hdr,
2368: PA_PROJ_ELEM_VER_STRUCTURE ppevs2,
2369: PJI_XBS_DENORM prg
2370: where
2371: prg.struct_version_id is null and
2372: sub_wbs_hdr.PLAN_VERSION_ID = p_plan_version_id and
2373: sub_wbs_hdr.PROJECT_ID = p_project_id and

Line 2417: index(prg PJI_XBS_DENORM_N1) */

2413: sup_wbs_hdr.PLAN_TYPE_ID,
2414: sup_wbs_hdr.PLAN_TYPE_CODE) in
2415: (
2416: select /*+ ordered
2417: index(prg PJI_XBS_DENORM_N1) */
2418: prg.SUP_PROJECT_ID,
2419: prg.SUP_ID,
2420: ver.BUDGET_VERSION_ID,
2421: ver.FIN_PLAN_TYPE_ID,

Line 2426: PJI_XBS_DENORM prg

2422: sub_wbs_hdr.PLAN_TYPE_CODE
2423: from
2424: PA_BUDGET_VERSIONS ver,
2425: PJI_PJP_WBS_HEADER sub_wbs_hdr,
2426: PJI_XBS_DENORM prg
2427: where
2428: ver.BUDGET_VERSION_ID = p_plan_version_id and
2429: ver.PROJECT_ID = sub_wbs_hdr.PROJECT_ID and
2430: ver.FIN_PLAN_TYPE_ID = sub_wbs_hdr.PLAN_TYPE_ID and

Line 2637: FROM pji_xbs_denorm den

2633:
2634: -- Are any of the relevant WPs locked? Refer Program Reporting Tech Arch for biz rules.
2635: SELECT COUNT(1)
2636: INTO l_num_locked
2637: FROM pji_xbs_denorm den
2638: , pji_pjp_wbs_header hd1 -- SUP
2639: , pji_pjp_wbs_header hd2 -- SUB
2640: , PA_PROJ_ELEM_VER_STRUCTURE ppevs1
2641: , PA_PROJ_ELEM_VER_STRUCTURE ppevs2

Line 2830: , pji_xbs_denorm den

2826: , 'Y' -- baselined flag.
2827: , bv.SECONDARY_RBS_FLAG
2828: , bv.lp_flag
2829: FROM pji_fm_extr_plnver3_T bv
2830: , pji_xbs_denorm den
2831: , ( SELECT -3 plan_version_id FROM DUAL
2832: UNION ALL
2833: SELECT -4 FROM DUAL ) cbco
2834: WHERE 1=1

Line 2862: FROM pji_xbs_denorm den

2858:
2859:
2860: SELECT COUNT(1)
2861: INTO l_count1
2862: FROM pji_xbs_denorm den
2863: , pji_pjp_wbs_header hd1 -- SUB
2864: , pji_pjp_wbs_header hd2 -- SUP
2865: , pa_budget_versions hd3 -- to get plan type id
2866: WHERE

Line 3487: index(prg PJI_XBS_DENORM_N1) */

3483: (sup_wbs_hdr.PROJECT_ID,
3484: sup_wbs_hdr.WBS_VERSION_ID) in
3485: (
3486: select /*+ ordered
3487: index(prg PJI_XBS_DENORM_N1) */
3488: prg.SUP_PROJECT_ID,
3489: prg.SUP_ID
3490: from
3491: PA_PJI_PROJ_EVENTS_LOG log,

Line 3494: PJI_XBS_DENORM prg

3490: from
3491: PA_PJI_PROJ_EVENTS_LOG log,
3492: PJI_PJP_WBS_HEADER sub_wbs_hdr,
3493: PA_PROJ_ELEM_VER_STRUCTURE ppevs2,
3494: PJI_XBS_DENORM prg
3495: where
3496: prg.STRUCT_VERSION_ID is null and
3497: sub_wbs_hdr.WBS_VERSION_ID = prg.SUB_ID and
3498: sup_wbs_hdr.WBS_VERSION_ID = prg.SUP_ID and

Line 3546: index(prg PJI_XBS_DENORM_N1) */

3542: sup_wbs_hdr.PLAN_TYPE_ID,
3543: sup_wbs_hdr.PLAN_TYPE_CODE) in
3544: (
3545: select /*+ ordered
3546: index(prg PJI_XBS_DENORM_N1) */
3547: prg.SUP_PROJECT_ID,
3548: prg.SUP_ID,
3549: sub_wbs_hdr.PLAN_VERSION_ID,
3550: sub_wbs_hdr.PLAN_TYPE_ID,

Line 3556: PJI_XBS_DENORM prg

3552: from
3553: PA_PJI_PROJ_EVENTS_LOG log,
3554: PJI_PJP_WBS_HEADER wbs_hdr,
3555: PJI_PJP_WBS_HEADER sub_wbs_hdr,
3556: PJI_XBS_DENORM prg
3557: where
3558: prg.STRUCT_VERSION_ID is null and
3559: sub_wbs_hdr.WBS_VERSION_ID = prg.SUB_ID and
3560: prg.STRUCT_TYPE = 'PRG' and

Line 3611: FROM pji_xbs_denorm den

3607: SELECT hd1.plan_version_id
3608: FROM pji_pjp_wbs_header hd1 -- SUP
3609: WHERE EXISTS (
3610: SELECT 1
3611: FROM pji_xbs_denorm den
3612: , pji_pjp_wbs_header hd2 -- SUB
3613: , PA_PROJ_WORKPLAN_ATTR ppwa1
3614: , PA_PROJ_ELEMENTS ppe1
3615: , PA_PROJ_STRUCTURE_TYPES ppst1

Line 5517: FROM pji_xbs_Denorm pji

5513: IF p_prg_rollup_flag='Y' THEN
5514: BEGIN
5515: SELECT distinct head.plan_version_id,head.project_id ,pji.sub_id wbs_version_id,head.plan_type_code BULK COLLECT
5516: into il_plan_version_id_tbl, il_project_id_tbl,il_wbs_version_id_tbl,il_plan_type_code_tbl /*4471527 */
5517: FROM pji_xbs_Denorm pji
5518: ,pa_proj_element_versions pa
5519: ,pji_pjp_wbs_header head
5520: WHERE pji.struct_type='PRG'
5521: and pji.sup_level<>pji.sub_level

Line 5964: SELECT /+ ORDERED INDEX(XBS PJI_XBS_DENORM_N2) /

5960: CUSTOM13,
5961: CUSTOM14,
5962: CUSTOM15,
5963: PLAN_TYPE_CODE ) /*4471527 */
5964: SELECT /*+ ORDERED INDEX(XBS PJI_XBS_DENORM_N2) */
5965: 1,
5966: 0,
5967: fact.PROJECT_ID,
5968: fact.PROJECT_ORG_ID,

Line 6041: pji_xbs_denorm xbs

6037: fact.PLAN_TYPE_CODE /*4471527 */
6038: FROM
6039: pji_fp_aggr_pjp1_t fact,
6040: pji_pjp_wbs_header head,
6041: pji_xbs_denorm xbs
6042: WHERE
6043: xbs.STRUCT_VERSION_ID = head.WBS_VERSION_ID AND
6044: xbs.STRUCT_TYPE = 'WBS' AND
6045: xbs.SUP_LEVEL <> xbs.SUB_LEVEL AND

Line 6158: SELECT /+ ORDERED INDEX(XBS PJI_XBS_DENORM_N2) /

6154: CUSTOM13,
6155: CUSTOM14,
6156: CUSTOM15,
6157: PLAN_TYPE_CODE ) /*4471527 */
6158: SELECT /*+ ORDERED INDEX(XBS PJI_XBS_DENORM_N2) */
6159: 1,
6160: 0,
6161: fact.PROJECT_ID,
6162: fact.PROJECT_ORG_ID,

Line 6235: pji_xbs_denorm xbs

6231: fact.PLAN_TYPE_CODE /*4471527 */
6232: FROM
6233: pji_fp_aggr_pjp1_t fact,
6234: pji_pjp_wbs_header head,
6235: pji_xbs_denorm xbs
6236:
6237: WHERE
6238: xbs.STRUCT_VERSION_ID = head.WBS_VERSION_ID AND
6239: xbs.STRUCT_TYPE = 'XBS' AND