DBA Data[Home] [Help]

APPS.MTH_UTIL_PKG dependencies on MTH_RESOURCE_COST_MV

Line 1266: MTH_EQUIP_PROD_SCH_PM_MV,MTH_EQUIP_SHFT_DD_MV,MTH_EQUIP_SHFT_PM_MV,MTH_RESOURCE_COST_MV,MTH_ITEM_COST_MV,MTH_ALL_ENTITIES_MV,MTH_ENTITY_PLANNED_USAGE_MV,

1262: p_atomic_refresh BOOLEAN := true;
1263: BEGIN
1264: p_list := 'MTH_SHIFT_GREGORIAN_DENORM_MV,MTH_RES_TXN_IT_MV,MTH_RES_TXN_LT_MV,MTH_MTL_CONS_IT_MV,MTH_MTL_CONS_LT_MV,MTH_MTL_PROD_IT_MV,MTH_MTL_PROD_LT_MV,
1265: MTH_RES_REQ_IT_MV,MTH_RES_REQ_LT_MV,MTH_EQUIP_OP_SUM_DD_MV,MTH_EQUIP_OP_SUM_PM_MV,MTH_EQUIP_ST_SUM_DD_MV,MTH_EQUIP_ST_SUM_PM_MV,MTH_EQUIP_PROD_SCH_DD_MV,
1266: MTH_EQUIP_PROD_SCH_PM_MV,MTH_EQUIP_SHFT_DD_MV,MTH_EQUIP_SHFT_PM_MV,MTH_RESOURCE_COST_MV,MTH_ITEM_COST_MV,MTH_ALL_ENTITIES_MV,MTH_ENTITY_PLANNED_USAGE_MV,
1267: MTH_ENTITY_PLANNED_USAGE_HR_MV,MTH_ENTITY_PLANNED_USAGE_SM_MV,MTH_445_PERIOD_CAL_HOUR_MV';
1268:
1269: IF(p_mview_name = 'ALL')
1270: THEN

Line 4083: MTH_EQUIPMENT_DENORM_D MED ,MTH_RESOURCE_COST_MV MRC

4079: MRC.RESOURCE_FK_KEY,
4080: MRC.COST
4081:
4082: FROM
4083: MTH_EQUIPMENT_DENORM_D MED ,MTH_RESOURCE_COST_MV MRC
4084: WHERE MED.EQUIPMENT_FK_KEY IS NOT NULL AND
4085: MED.EQUIPMENT_HIERARCHY_KEY = -2
4086: AND MED.LEVEL9_LEVEL_KEY = MRC.RESOURCE_FK_KEY (+))COST
4087: WHERE