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_AATP_FUNC dependencies on MSC_ITEM_HIERARCHY_MV

Line 305: FROM msc_item_hierarchy_mv

301:
302: /*
303: SELECT allocation_percent/100
304: INTO l_alloc_percent
305: FROM msc_item_hierarchy_mv
306: WHERE demand_class = p_demand_class
307: AND inventory_item_id = p_inv_item_id
308: AND organization_id = p_org_id
309: AND sr_instance_id = p_instance_id

Line 329: FROM msc_item_hierarchy_mv

325: END IF;
326:
327: SELECT allocation_percent/100
328: INTO l_alloc_percent
329: FROM msc_item_hierarchy_mv
330: WHERE inventory_item_id = p_inv_item_id
331: AND organization_id = p_org_id
332: AND sr_instance_id = p_instance_id
333: AND demand_class = p_demand_class

Line 350: FROM msc_item_hierarchy_mv

346: BEGIN
347:
348: SELECT allocation_percent/100
349: INTO l_alloc_percent
350: FROM msc_item_hierarchy_mv
351: WHERE inventory_item_id = p_inv_item_id
352: AND organization_id = p_org_id
353: AND sr_instance_id = p_instance_id
354: AND demand_class = p_demand_class

Line 363: FROM msc_item_hierarchy_mv

359:
360: WHEN NO_DATA_FOUND THEN
361: SELECT DECODE(count(allocation_percent), 0, NULL, 0)
362: INTO l_alloc_percent
363: FROM msc_item_hierarchy_mv
364: WHERE inventory_item_id = p_inv_item_id
365: AND organization_id = p_org_id
366: AND sr_instance_id = p_instance_id
367: AND (p_request_date between effective_date and disable_date

Line 378: FROM msc_item_hierarchy_mv

374: END IF;
375:
376: SELECT DECODE(count(allocation_percent), 0, NULL, 0)
377: INTO l_alloc_percent
378: FROM msc_item_hierarchy_mv
379: WHERE inventory_item_id = p_inv_item_id
380: AND organization_id = p_org_id
381: AND sr_instance_id = p_instance_id
382: AND p_request_date between effective_date and disable_date

Line 394: FROM msc_item_hierarchy_mv

390: END IF;
391:
392: SELECT allocation_percent/100
393: INTO l_alloc_percent
394: FROM msc_item_hierarchy_mv
395: WHERE inventory_item_id = p_inv_item_id
396: AND organization_id = p_org_id
397: AND sr_instance_id = p_instance_id
398: AND demand_class = p_demand_class

Line 413: FROM msc_item_hierarchy_mv

409: BEGIN
410:
411: SELECT allocation_percent/100
412: INTO l_alloc_percent
413: FROM msc_item_hierarchy_mv
414: WHERE inventory_item_id = p_inv_item_id
415: AND organization_id = p_org_id
416: AND sr_instance_id = p_instance_id
417: AND demand_class = p_demand_class

Line 426: FROM msc_item_hierarchy_mv

422: WHEN NO_DATA_FOUND THEN
423:
424: SELECT DECODE(count(allocation_percent), 0, NULL, 0)
425: INTO l_alloc_percent
426: FROM msc_item_hierarchy_mv
427: WHERE inventory_item_id = p_inv_item_id
428: AND organization_id = p_org_id
429: AND sr_instance_id = p_instance_id
430: AND (p_request_date between effective_date and disable_date

Line 437: FROM msc_item_hierarchy_mv

433: END;
434: ELSE
435: SELECT DECODE(count(allocation_percent), 0, NULL, 0)
436: INTO l_alloc_percent
437: FROM msc_item_hierarchy_mv
438: WHERE inventory_item_id = p_inv_item_id
439: AND organization_id = p_org_id
440: AND sr_instance_id = p_instance_id
441: AND p_request_date between effective_date and disable_date

Line 709: FROM msc_item_hierarchy_mv

705: BEGIN
706: --diag_atp
707: SELECT distinct time_phase_id, allocation_rule_name
708: INTO l_time_phase_id, MSC_ATP_PVT.G_ALLOCATION_RULE_NAME
709: FROM msc_item_hierarchy_mv
710: WHERE inventory_item_id = p_inventory_item_id
711: AND organization_id = p_organization_id
712: AND sr_instance_id = p_instance_id
713: AND greatest(p_request_date,trunc(sysdate)) between effective_date and disable_date; --bug3099066

Line 777: FROM msc_item_hierarchy_mv

773: BEGIN
774: --diag_atp
775: SELECT distinct time_phase_id, allocation_rule_name
776: INTO l_time_phase_id, MSC_ATP_PVT.G_ALLOCATION_RULE_NAME
777: FROM msc_item_hierarchy_mv
778: WHERE inventory_item_id = p_inventory_item_id
779: AND organization_id = p_organization_id
780: AND sr_instance_id = p_instance_id
781: AND greatest(p_request_date,trunc(sysdate)) between effective_date and disable_date; --bug3099066

Line 1211: FROM msc_item_hierarchy_mv

1207: IF G_HIERARCHY_PROFILE = 1 THEN
1208:
1209: SELECT (allocation_percent- NVL(min_allocation_percent,0))/100
1210: INTO l_alloc_percent
1211: FROM msc_item_hierarchy_mv
1212: WHERE demand_class = p_demand_class
1213: AND inventory_item_id = p_inv_item_id
1214: AND organization_id = p_org_id
1215: AND sr_instance_id = p_instance_id

Line 1223: FROM msc_item_hierarchy_mv

1219: ELSE
1220:
1221: SELECT (allocation_percent- NVL(min_allocation_percent,0))/100
1222: INTO l_alloc_percent
1223: FROM msc_item_hierarchy_mv
1224: WHERE demand_class = p_demand_class
1225: AND inventory_item_id = p_inv_item_id
1226: AND organization_id = p_org_id
1227: AND sr_instance_id = p_instance_id

Line 1241: FROM msc_item_hierarchy_mv

1237: IF G_HIERARCHY_PROFILE = 1 THEN
1238:
1239: SELECT DECODE(count(allocation_percent), 0, NULL, 0)
1240: INTO l_alloc_percent
1241: FROM msc_item_hierarchy_mv
1242: WHERE inventory_item_id = p_inv_item_id
1243: AND organization_id = p_org_id
1244: AND sr_instance_id = p_instance_id
1245: AND p_request_date between effective_date and disable_date

Line 1252: FROM msc_item_hierarchy_mv

1248: ELSE
1249:
1250: SELECT DECODE(count(allocation_percent), 0, NULL, 0)
1251: INTO l_alloc_percent
1252: FROM msc_item_hierarchy_mv
1253: WHERE inventory_item_id = p_inv_item_id
1254: AND organization_id = p_org_id
1255: AND sr_instance_id = p_instance_id
1256: AND p_request_date between effective_date and disable_date