APPS.PJI_PJP_SUM_MAIN dependencies on PJI_XBS_DENORM

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

963: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
964: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
965:
966: cursor C_BOTTOM_UP is
967: select /*+ INDEX_FFS (den PJI_XBS_DENORM_N3) */
968: SUP_LEVEL
969: from
970: PJI_XBS_DENORM den
971: where

Line 970: PJI_XBS_DENORM den

966: cursor C_BOTTOM_UP is
967: select /*+ INDEX_FFS (den PJI_XBS_DENORM_N3) */
968: SUP_LEVEL
969: from
970: PJI_XBS_DENORM den
971: where
972: STRUCT_TYPE = 'PRG' and
973: SUB_LEVEL = SUP_LEVEL and
974: EXISTS ( SELECT 1 from PJI_FM_EXTR_PLNVER4 ver where ver.worker_id = p_worker_id

Line 1135: , pji_xbs_denorm den

1131: , DECODE(cbco.plan_version_id, -3, 'Y', 'N') baselined_flag
1132: , bv.SECONDARY_RBS_FLAG
1133: , bv.lp_flag
1134: FROM PJI_FM_EXTR_PLNVER4 bv
1135: , pji_xbs_denorm den
1136: , ( SELECT -3 plan_version_id FROM DUAL
1137: UNION ALL
1138: SELECT -4 FROM DUAL ) cbco
1139: WHERE 1=1

Line 2088: PJI_XBS_DENORM prg,

2084: from
2085: PJI_FP_AGGR_PJP1 pjp1,
2086: PJI_PJP_WBS_HEADER wbs_hdr,
2087: PA_XBS_DENORM wbs,
2088: PJI_XBS_DENORM prg,
2089: (
2090: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
2091: from DUAL union all
2092: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 2241: PJI_XBS_DENORM prg,

2237: pjp1.CUSTOM15
2238: from
2239: PJI_FP_AGGR_PJP1 pjp1,
2240: PJI_PJP_WBS_HEADER wbs_hdr,
2241: PJI_XBS_DENORM prg,
2242: (
2243: select 'Y' CB_FLAG,
2244: 'N' CO_FLAG,
2245: -3 PLAN_VERSION_ID

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

2288: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
2289: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
2290: ) pjp,
2291: (
2292: select /*+ index(prg PJI_XBS_DENORM_N3)
2293: index(map PA_PROJECTS_U1) */
2294: prg.SUP_PROJECT_ID,
2295: map.ORG_ID SUP_PROJECT_ORG_ID,
2296: map.CARRYING_OUT_ORGANIZATION_ID SUP_PROJECT_ORGANIZATION_ID,

Line 2309: PJI_XBS_DENORM prg,

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

Line 3385: index(prg1 PJI_XBS_DENORM_N3)

3381: ver2.OBJECT_TYPE = 'PA_STRUCTURES' and
3382: ver2.PRG_GROUP = ver1.PRG_GROUP
3383: union
3384: select /*+ ordered
3385: index(prg1 PJI_XBS_DENORM_N3)
3386: index(prg2 PJI_XBS_DENORM_N3) */
3387: distinct
3388: prg2.SUP_PROJECT_ID PROJECT_ID
3389: from

Line 3386: index(prg2 PJI_XBS_DENORM_N3) */

3382: ver2.PRG_GROUP = ver1.PRG_GROUP
3383: union
3384: select /*+ ordered
3385: index(prg1 PJI_XBS_DENORM_N3)
3386: index(prg2 PJI_XBS_DENORM_N3) */
3387: distinct
3388: prg2.SUP_PROJECT_ID PROJECT_ID
3389: from
3390: PJI_PJP_PROJ_BATCH_MAP map,

Line 3391: PJI_XBS_DENORM prg1,

3387: distinct
3388: prg2.SUP_PROJECT_ID PROJECT_ID
3389: from
3390: PJI_PJP_PROJ_BATCH_MAP map,
3391: PJI_XBS_DENORM prg1,
3392: PJI_XBS_DENORM prg2
3393: where
3394: map.WORKER_ID = p_worker_id and
3395: prg1.STRUCT_TYPE = 'PRG' and

Line 3392: PJI_XBS_DENORM prg2

3388: prg2.SUP_PROJECT_ID PROJECT_ID
3389: from
3390: PJI_PJP_PROJ_BATCH_MAP map,
3391: PJI_XBS_DENORM prg1,
3392: PJI_XBS_DENORM prg2
3393: where
3394: map.WORKER_ID = p_worker_id and
3395: prg1.STRUCT_TYPE = 'PRG' and
3396: prg1.SUP_PROJECT_ID = map.PROJECT_ID and