APPS.MSC_AATP_FUNC dependencies on MSC_DEMANDS

Line 125: from msc_demands d

121: IF G_HIERARCHY_PROFILE = 1 THEN
122: -- demand class
123: select 1
124: into l_alloc_percent
125: from msc_demands d
126: --5027568
127: where decode(d.origination_type, -100, 30, d.origination_type) in (6, 30)--DEMAND_SALES_ORDER
128: and d.plan_id = p_plan_id
129: and d.demand_id = p_demand_id

Line 132: /* bug 2783787 - demand_class is always available in msc_demands

128: and d.plan_id = p_plan_id
129: and d.demand_id = p_demand_id
130: and NVL(d.demand_class,'-1') = p_demand_class;
131:
132: /* bug 2783787 - demand_class is always available in msc_demands
133: no need to look in msc_sales_orders
134: select 1
135: into l_alloc_percent
136: from msc_sales_orders so,

Line 137: msc_demands d

133: no need to look in msc_sales_orders
134: select 1
135: into l_alloc_percent
136: from msc_sales_orders so,
137: msc_demands d
138: where d.origination_type in (6, 30) --DEMAND_SALES_ORDER
139: and d.plan_id = p_plan_id
140: and d.demand_id = p_demand_id
141: and d.reservation_id = so.demand_id

Line 153: from msc_demands d

149:
150: ELSIF G_HIERARCHY_PROFILE = 2 THEN
151: select 1
152: into l_alloc_percent
153: from msc_demands d
154: where d.plan_id = p_plan_id
155: and d.demand_id = p_demand_id
156: and MSC_AATP_FUNC.get_hierarchy_demand_class(d.customer_id, d.ship_to_site_id,d.inventory_item_id, d.organization_id, d.sr_instance_id, p_demand_date, p_level_id, null) = p_demand_class;
157:

Line 182: msc_demands d

178: /*
179: SELECT 1
180: INTO l_alloc_percent
181: FROM msc_sales_orders so,
182: msc_demands d
183: WHERE d.demand_id = p_demand_id
184: AND d.plan_id = p_plan_id
185: AND so.demand_id = d.reservation_id
186: AND so.sr_instance_id = d.sr_instance_id