APPS.MSC_AATP_REQ dependencies on MSC_ITEM_HIERARCHY_MV

Line 1066: FROM msc_item_hierarchy_mv mv

1062: IF MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1 THEN
1063:
1064: SELECT mv.priority, mv.level_id, mv.class, mv.partner_id
1065: INTO l_priority, l_level_id, l_class, l_partner_id
1066: FROM msc_item_hierarchy_mv mv
1067: WHERE mv.inventory_item_id = l_item_to_use /* New allocation logic for time_phased_atp changes*/
1068: AND mv.organization_id = p_organization_id
1069: AND mv.sr_instance_id = p_instance_id
1070: --bug 3589115: if allocation rule is not valid on request date then pick one applicable on sysdate

Line 1079: FROM msc_item_hierarchy_mv mv

1075: ELSE
1076:
1077: SELECT mv.priority, mv.level_id, mv.class, mv.partner_id
1078: INTO l_priority, l_level_id, l_class, l_partner_id
1079: FROM msc_item_hierarchy_mv mv
1080: WHERE mv.inventory_item_id = l_item_to_use /* New allocation logic for time_phased_atp changes*/
1081: AND mv.organization_id = p_organization_id
1082: AND mv.sr_instance_id = p_instance_id
1083: --bug 3589115: if allocation rule is not valid on request date then pick one applicable on sysdate

Line 1106: FROM msc_item_hierarchy_mv mv

1102: -- Order by clause reversed as we'll add request demand class at the end and acces the list bottom-up.
1103:
1104: SELECT mv.demand_class, mv.priority
1105: BULK COLLECT INTO l_demand_class_tab, l_demand_class_priority_tab
1106: FROM msc_item_hierarchy_mv mv
1107: WHERE mv.inventory_item_id = l_item_to_use /* New allocation logic for time_phased_atp changes*/
1108: AND mv.organization_id = p_organization_id
1109: AND mv.sr_instance_id = p_instance_id
1110: --bug 3589115: if allocation rule is not valid on request date then pick one applicable on sysdate