APPS.PJI_PJP_SUM_MAIN dependencies on PJI_XBS_DENORM

Line 944: select /*+ INDEX_FFS (den PJI_XBS_DENORM_N3) */

940: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
941: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
942:
943: cursor C_BOTTOM_UP is
944: select /*+ INDEX_FFS (den PJI_XBS_DENORM_N3) */
945: SUP_LEVEL
946: from
947: PJI_XBS_DENORM den
948: where

Line 947: PJI_XBS_DENORM den

943: cursor C_BOTTOM_UP is
944: select /*+ INDEX_FFS (den PJI_XBS_DENORM_N3) */
945: SUP_LEVEL
946: from
947: PJI_XBS_DENORM den
948: where
949: STRUCT_TYPE = 'PRG' and
950: SUB_LEVEL = SUP_LEVEL and
951: EXISTS ( SELECT 1 from PJI_FM_EXTR_PLNVER4 ver where ver.worker_id = p_worker_id

Line 1112: , pji_xbs_denorm den

1108: , DECODE(cbco.plan_version_id, -3, 'Y', 'N') baselined_flag
1109: , bv.SECONDARY_RBS_FLAG
1110: , bv.lp_flag
1111: FROM PJI_FM_EXTR_PLNVER4 bv
1112: , pji_xbs_denorm den
1113: , ( SELECT -3 plan_version_id FROM DUAL
1114: UNION ALL
1115: SELECT -4 FROM DUAL ) cbco
1116: WHERE 1=1

Line 2065: PJI_XBS_DENORM prg,

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
2069: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 2218: PJI_XBS_DENORM prg,

2214: pjp1.CUSTOM15
2215: from
2216: PJI_FP_AGGR_PJP1 pjp1,
2217: PJI_PJP_WBS_HEADER wbs_hdr,
2218: PJI_XBS_DENORM prg,
2219: (
2220: select 'Y' CB_FLAG,
2221: 'N' CO_FLAG,
2222: -3 PLAN_VERSION_ID

Line 2269: select /*+ index(prg PJI_XBS_DENORM_N3)

2265: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
2266: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
2267: ) pjp,
2268: (
2269: select /*+ index(prg PJI_XBS_DENORM_N3)
2270: index(map PA_PROJECTS_U1) */
2271: prg.SUP_PROJECT_ID,
2272: map.ORG_ID SUP_PROJECT_ORG_ID,
2273: map.CARRYING_OUT_ORGANIZATION_ID SUP_PROJECT_ORGANIZATION_ID,

Line 2286: PJI_XBS_DENORM prg,

2282: 'LW', 'Y',
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

Line 3242: index(prg1 PJI_XBS_DENORM_N3)

3238: ver2.OBJECT_TYPE = 'PA_STRUCTURES' and
3239: ver2.PRG_GROUP = ver1.PRG_GROUP
3240: union
3241: select /*+ ordered
3242: index(prg1 PJI_XBS_DENORM_N3)
3243: index(prg2 PJI_XBS_DENORM_N3) */
3244: distinct
3245: prg2.SUP_PROJECT_ID PROJECT_ID
3246: from

Line 3243: index(prg2 PJI_XBS_DENORM_N3) */

3239: ver2.PRG_GROUP = ver1.PRG_GROUP
3240: union
3241: select /*+ ordered
3242: index(prg1 PJI_XBS_DENORM_N3)
3243: index(prg2 PJI_XBS_DENORM_N3) */
3244: distinct
3245: prg2.SUP_PROJECT_ID PROJECT_ID
3246: from
3247: PJI_PJP_PROJ_BATCH_MAP map,

Line 3248: PJI_XBS_DENORM prg1,

3244: distinct
3245: prg2.SUP_PROJECT_ID PROJECT_ID
3246: from
3247: PJI_PJP_PROJ_BATCH_MAP map,
3248: PJI_XBS_DENORM prg1,
3249: PJI_XBS_DENORM prg2
3250: where
3251: map.WORKER_ID = p_worker_id and
3252: prg1.STRUCT_TYPE = 'PRG' and

Line 3249: PJI_XBS_DENORM prg2

3245: prg2.SUP_PROJECT_ID PROJECT_ID
3246: from
3247: PJI_PJP_PROJ_BATCH_MAP map,
3248: PJI_XBS_DENORM prg1,
3249: PJI_XBS_DENORM prg2
3250: where
3251: map.WORKER_ID = p_worker_id and
3252: prg1.STRUCT_TYPE = 'PRG' and
3253: prg1.SUP_PROJECT_ID = map.PROJECT_ID and