APPS.MTH_UTIL_PKG dependencies on MTH_EQUIPMENT_DENORM_D

Line 1370: * in the mth_equipment_denorm_d table *

1366:
1367: /* *****************************************************************************
1368: * Procedure :PUT_EQUIP_DENORM_LEVEL_NUM *
1369: * Description :This procedure is used to insert the level_num column *
1370: * in the mth_equipment_denorm_d table *
1371: * File Name :MTHUTILB.PLS *
1372: * Visibility :Private *
1373: * Modification log : *
1374: * Author Date Change *

Line 1381: UPDATE MTH_EQUIPMENT_DENORM_D SET LEVEL_NUM = (

1377:
1378: PROCEDURE PUT_EQUIP_DENORM_LEVEL_NUM
1379: IS
1380: BEGIN
1381: UPDATE MTH_EQUIPMENT_DENORM_D SET LEVEL_NUM = (
1382: CASE WHEN EQUIPMENT_FK_KEY IS NOT NULL THEN 10
1383: ELSE CASE WHEN LEVEL9_LEVEL_KEY IS NOT NULL THEN 9
1384: ELSE CASE WHEN LEVEL8_LEVEL_KEY IS NOT NULL THEN 8
1385: ELSE CASE WHEN LEVEL7_LEVEL_KEY IS NOT NULL THEN 7

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