APPS.PJI_FM_SUM_ROLLUP_ACT dependencies on PJI_AC_PROJ_F

Line 828: index(acp, PJI_AC_PROJ_F_N2)

824: union all -- snapshot reversals - PART 1 - GL dates
825: -- Select old ITD amounts for snapshots with
826: -- reverse sign from base level fact
827: select /*+ ordered full(map) parallel(map)
828: index(acp, PJI_AC_PROJ_F_N2)
829: use_nl(acp)
830: full(info) */
831: p_worker_id WORKER_ID,
832: acp.PROJECT_ID,

Line 878: PJI_AC_PROJ_F acp,

874: to_number(null) ACTIVE_BACKLOG,
875: to_number(null) REVENUE_AT_RISK
876: from
877: PJI_PJI_PROJ_BATCH_MAP map,
878: PJI_AC_PROJ_F acp,
879: FII_TIME_RPT_STRUCT cal,
880: PJI_ORG_EXTR_INFO info
881: where
882: map.WORKER_ID = p_worker_id and

Line 905: index(acp, PJI_AC_PROJ_F_N2)

901: union all -- snapshot reversals - PART 2 - PA dates
902: -- Select old ITD amounts for snapshots with
903: -- reverse sign from base level fact
904: select /*+ ordered full(map) parallel(map)
905: index(acp, PJI_AC_PROJ_F_N2)
906: use_nl(acp)
907: full(info) */
908: p_worker_id WORKER_ID,
909: acp.PROJECT_ID,

Line 956: PJI_AC_PROJ_F acp,

952: to_number(null) REVENUE_AT_RISK
953:
954: from
955: PJI_PJI_PROJ_BATCH_MAP map,
956: PJI_AC_PROJ_F acp,
957: PJI_ORG_EXTR_INFO info,
958: FII_TIME_CAL_RPT_STRUCT cal
959: where
960: l_pa_calendar_flag = 'Y' and

Line 986: index(acp, PJI_AC_PROJ_F_N2)

982: union all -- snapshot reversals - PART 3 - PA day for week subst.
983: -- Select old ITD amounts for snapshots with
984: -- reverse sign from base level fact
985: select /*+ ordered full(map) parallel(map)
986: index(acp, PJI_AC_PROJ_F_N2)
987: use_nl(acp)
988: full(info) */
989: p_worker_id WORKER_ID,
990: acp.PROJECT_ID,

Line 1037: PJI_AC_PROJ_F acp,

1033: to_number(null) REVENUE_AT_RISK
1034:
1035: from
1036: PJI_PJI_PROJ_BATCH_MAP map,
1037: PJI_AC_PROJ_F acp,
1038: PJI_ORG_EXTR_INFO info,
1039: PJI_TIME_PA_RPT_STR_MV cal
1040: where
1041: l_pa_calendar_flag = 'Y' and

Line 1870: insert /*+ append parallel(acp) */ into PJI_AC_PROJ_F acp

1866: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1867:
1868: if (l_extraction_type = 'FULL' and nvl(p_backlog_flag, 'N') = 'N') then
1869:
1870: insert /*+ append parallel(acp) */ into PJI_AC_PROJ_F acp
1871: (
1872: PROJECT_ORG_ID,
1873: PROJECT_ORGANIZATION_ID,
1874: TIME_ID,

Line 2002: merge /*+ parallel(acp) */ into PJI_AC_PROJ_F acp

1998: nvl(REVENUE_AT_RISK , 0) <> 0);
1999:
2000: else -- not initial data load
2001:
2002: merge /*+ parallel(acp) */ into PJI_AC_PROJ_F acp
2003: using
2004: (
2005: select
2006: PROJECT_ORG_ID,

Line 2141: index(acp, PJI_AC_PROJ_F_N2) use_nl(acp) */

2137: from
2138: PJI_FM_AGGR_ACT3 act
2139: union all -- partial refresh
2140: select /*+ ordered full(map) parallel(map)
2141: index(acp, PJI_AC_PROJ_F_N2) use_nl(acp) */
2142: acp.PROJECT_ORG_ID,
2143: acp.PROJECT_ORGANIZATION_ID,
2144: acp.TIME_ID,
2145: acp.PROJECT_ID,

Line 2184: PJI_AC_PROJ_F acp

2180: to_number(null) ACTIVE_BACKLOG,
2181: to_number(null) REVENUE_AT_RISK
2182: from
2183: PJI_PJI_PROJ_BATCH_MAP map,
2184: PJI_AC_PROJ_F acp
2185: where
2186: nvl(p_backlog_flag, 'N') = 'N' and
2187: l_extraction_type = 'PARTIAL' and
2188: map.WORKER_ID = p_worker_id and

Line 2692: Update PJI_AC_PROJ_F

2688: l_last_fetch := 'N';
2689: END IF;
2690:
2691: FORALL I in L_PROJECT_TAB.FIRST..L_PROJECT_TAB.LAST
2692: Update PJI_AC_PROJ_F
2693: Set PROJECT_ORGANIZATION_ID = L_NEW_ORGZ_TAB(I)
2694: Where PROJECT_ID = L_PROJECT_TAB(I)
2695: ;
2696:

Line 2782: TABNAME => 'MLOG$_PJI_AC_PROJ_F',

2778: 'C',
2779: 'N');
2780: else
2781: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,
2782: TABNAME => 'MLOG$_PJI_AC_PROJ_F',
2783: PERCENT => 10,
2784: DEGREE => l_p_degree);
2785: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
2786: l_retcode,