eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_ATP_REQ dependencies on MSC_NET_RESOURCE_AVAIL

Line 215: FROM MSC_NET_RESOURCE_AVAIL

211: SELECT trunc(SHIFT_DATE) SD_DATE,--4135752
212: CAPACITY_UNITS * ((DECODE(LEAST(from_time, to_time),
213: to_time,to_time + 24*3600,
214: to_time) - from_time)/3600) SD_QTY
215: FROM MSC_NET_RESOURCE_AVAIL
216: WHERE PLAN_ID = p_plan_id
217: AND NVL(PARENT_ID, -2) <> -1
218: AND SR_INSTANCE_ID = p_instance_id
219: AND RESOURCE_ID = p_res_id

Line 323: FROM MSC_NET_RESOURCE_AVAIL

319: SELECT trunc(SHIFT_DATE) SD_DATE,--4135752
320: CAPACITY_UNITS * ((DECODE(LEAST(from_time, to_time),
321: to_time,to_time + 24*3600,
322: to_time) - from_time)/3600) SD_QTY
323: FROM MSC_NET_RESOURCE_AVAIL
324: WHERE PLAN_ID = p_plan_id
325: AND NVL(PARENT_ID, -2) <> -1
326: AND SR_INSTANCE_ID = p_instance_id
327: AND RESOURCE_ID = p_res_id

Line 449: FROM MSC_NET_RESOURCE_AVAIL

445: SELECT trunc(SHIFT_DATE) SD_DATE,--4135752
446: CAPACITY_UNITS * ((DECODE(LEAST(from_time, to_time),
447: to_time,to_time + 24*3600,
448: to_time) - from_time)/3600)* p_max_capacity * p_res_conv_rate SD_QTY
449: FROM MSC_NET_RESOURCE_AVAIL
450: WHERE PLAN_ID = p_plan_id
451: AND NVL(PARENT_ID, -2) <> -1
452: AND SR_INSTANCE_ID = p_instance_id
453: AND RESOURCE_ID = p_res_id

Line 578: FROM MSC_NET_RESOURCE_AVAIL

574: SELECT trunc(SHIFT_DATE) SD_DATE, --4135752
575: CAPACITY_UNITS * ((DECODE(LEAST(from_time, to_time),
576: to_time,to_time + 24*3600,
577: to_time) - from_time)/3600)* p_max_capacity * p_res_conv_rate SD_QTY
578: FROM MSC_NET_RESOURCE_AVAIL
579: WHERE PLAN_ID = p_plan_id
580: AND NVL(PARENT_ID, -2) <> -1
581: AND SR_INSTANCE_ID = p_instance_id
582: AND RESOURCE_ID = p_res_id

Line 786: FROM MSC_NET_RESOURCE_AVAIL

782: FND_GLOBAL.User_ID,
783: l_sysdate,
784: FND_GLOBAL.User_ID,
785: FND_GLOBAL.User_ID
786: FROM MSC_NET_RESOURCE_AVAIL
787: WHERE PLAN_ID = p_plan_id
788: AND NVL(PARENT_ID, -2) <> -1
789: AND SR_INSTANCE_ID = p_instance_id
790: AND RESOURCE_ID = p_res_id

Line 994: FROM MSC_NET_RESOURCE_AVAIL

990: FND_GLOBAL.User_ID,
991: l_sysdate,
992: FND_GLOBAL.User_ID,
993: FND_GLOBAL.User_ID
994: FROM MSC_NET_RESOURCE_AVAIL
995: WHERE PLAN_ID = p_plan_id
996: AND NVL(PARENT_ID, -2) <> -1
997: AND SR_INSTANCE_ID = p_instance_id
998: AND RESOURCE_ID = p_res_id

Line 1214: FROM MSC_NET_RESOURCE_AVAIL

1210: FND_GLOBAL.User_ID,
1211: l_sysdate,
1212: FND_GLOBAL.User_ID,
1213: FND_GLOBAL.User_ID
1214: FROM MSC_NET_RESOURCE_AVAIL
1215: WHERE PLAN_ID = p_plan_id
1216: AND NVL(PARENT_ID, -2) <> -1
1217: AND SR_INSTANCE_ID = p_instance_id
1218: AND RESOURCE_ID = p_res_id

Line 1440: FROM MSC_NET_RESOURCE_AVAIL

1436: FND_GLOBAL.User_ID,
1437: l_sysdate,
1438: FND_GLOBAL.User_ID,
1439: FND_GLOBAL.User_ID
1440: FROM MSC_NET_RESOURCE_AVAIL
1441: WHERE PLAN_ID = p_plan_id
1442: AND NVL(PARENT_ID, -2) <> -1
1443: AND SR_INSTANCE_ID = p_instance_id
1444: AND RESOURCE_ID = p_res_id