DBA Data[Home] [Help]

APPS.PJI_RM_SUM_AVL dependencies on PJI_AV_ORG_F

Line 4093: MERGE /*+ parallel(rmr) */ into PJI_AV_ORG_F rmr

4089:
4090: /* Group all the records based on periods and
4091: MERGE IN the fact table
4092: */
4093: MERGE /*+ parallel(rmr) */ into PJI_AV_ORG_F rmr
4094: USING
4095: (
4096: SELECT
4097: rtmp.EXPENDITURE_ORGANIZATION_ID as EXPENDITURE_ORGANIZATION_ID,

Line 4962: TABNAME => 'MLOG$_PJI_AV_ORG_F',

4958: ELSE
4959:
4960: FND_STATS.GATHER_TABLE_STATS
4961: (OWNNAME => l_pji_schema,
4962: TABNAME => 'MLOG$_PJI_AV_ORG_F',
4963: PERCENT => 10,
4964: DEGREE => l_p_degree);
4965:
4966: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,