APPS.PJI_FM_SUM_ROLLUP_FIN dependencies on PJI_FP_PROJ_ET_F

Line 3812: insert /*+ append parallel(fpe) */ into PJI_FP_PROJ_ET_F fpe

3808: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3809:
3810: if (l_extraction_type = 'FULL') then
3811:
3812: insert /*+ append parallel(fpe) */ into PJI_FP_PROJ_ET_F fpe
3813: (
3814: PROJECT_ORG_ID,
3815: PROJECT_ORGANIZATION_ID,
3816: TIME_ID,

Line 3907: merge /*+ parallel(fpe) */ into PJI_FP_PROJ_ET_F fpe

3903: nvl(fin5.BILL_QUANTITY , 0) <> 0);
3904:
3905: else -- not initial data load
3906:
3907: merge /*+ parallel(fpe) */ into PJI_FP_PROJ_ET_F fpe
3908: using
3909: (
3910: select
3911: PROJECT_ORG_ID,

Line 4014: index(fpe, PJI_FP_PROJ_ET_F_N2) use_nl(fpe) */

4010: where
4011: fin5.WORKER_ID = p_worker_id
4012: union all -- partial refresh
4013: select /*+ ordered full(map) parallel(map)
4014: index(fpe, PJI_FP_PROJ_ET_F_N2) use_nl(fpe) */
4015: fpe.PROJECT_ORG_ID,
4016: fpe.PROJECT_ORGANIZATION_ID,
4017: fpe.TIME_ID,
4018: fpe.PROJECT_ID,

Line 4043: PJI_FP_PROJ_ET_F fpe

4039: -fpe.QUANTITY,
4040: -fpe.BILL_QUANTITY
4041: from
4042: PJI_PJI_PROJ_BATCH_MAP map,
4043: PJI_FP_PROJ_ET_F fpe
4044: where
4045: l_extraction_type = 'PARTIAL' and
4046: map.WORKER_ID = p_worker_id and
4047: map.EXTRACTION_TYPE = 'P' and

Line 5080: Update PJI_FP_PROJ_ET_F

5076: Where PROJECT_ID = L_PROJECT_TAB(I)
5077: ;
5078:
5079: FORALL I in L_PROJECT_TAB.FIRST..L_PROJECT_TAB.LAST
5080: Update PJI_FP_PROJ_ET_F
5081: Set PROJECT_ORGANIZATION_ID = L_NEW_ORGZ_TAB(I)
5082: Where PROJECT_ID = L_PROJECT_TAB(I)
5083: ;
5084:

Line 5375: TABNAME => 'MLOG$_PJI_FP_PROJ_ET_F',

5371: 'C',
5372: 'N');
5373: else
5374: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,
5375: TABNAME => 'MLOG$_PJI_FP_PROJ_ET_F',
5376: PERCENT => 10,
5377: DEGREE => l_p_degree);
5378: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
5379: l_retcode,