APPS.PJI_PJP_SUM_MAIN dependencies on PA_XBS_DENORM

Line 1950: select /*+ ordered index(wbs PA_XBS_DENORM_N2) */

1946: sum(pjp.CUSTOM14) CUSTOM14,
1947: sum(pjp.CUSTOM15) CUSTOM15
1948: from
1949: (
1950: select /*+ ordered index(wbs PA_XBS_DENORM_N2) */
1951: -- get incremental task level amounts from source and
1952: -- program rollup amounts from interim
1953: to_char(null) LINE_TYPE,
1954: wbs_hdr.WBS_VERSION_ID,

Line 2064: PA_XBS_DENORM wbs,

2060: pjp1.CUSTOM15
2061: from
2062: PJI_FP_AGGR_PJP1 pjp1,
2063: PJI_PJP_WBS_HEADER wbs_hdr,
2064: PA_XBS_DENORM wbs,
2065: PJI_XBS_DENORM prg,
2066: (
2067: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
2068: from DUAL union all

Line 3145: index(prg, PA_XBS_DENORM_N3)

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
3147: emt.PROJECT_ID
3148: from
3149: PA_PROJECT_STATUSES stat,

Line 3151: PA_XBS_DENORM prg,

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
3155: stat.PROJECT_SYSTEM_STATUS_CODE not in ('CLOSED',

Line 3340: index(prg, PA_XBS_DENORM_N3)

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)
3341: distinct
3342: emt.PROJECT_ID
3343: from
3344: PA_PROJECT_STATUSES stat,

Line 3346: PA_XBS_DENORM prg,

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
3350: stat.PROJECT_SYSTEM_STATUS_CODE not in ('CLOSED',