APPS.MSC_PQ_UTILS dependencies on MSC_DEMANDS

Line 130: FROM msc_demands dem,

126: p_from_date IN DATE,
127: p_to_date IN DATE ) IS
128: SELECT dem.demand_id transaction_id
129: --,dem.using_assembly_demand_date new_due_date
130: FROM msc_demands dem,
131: msc_system_items msi,
132: msc_item_categories mic
133: WHERE mic.sr_instance_id = dem.sr_instance_id
134: AND mic.organization_id = dem.organization_id

Line 252: FROM msc_demands dem,

248: p_from_date IN DATE,
249: p_to_date IN DATE ) IS
250: SELECT dem.demand_id transaction_id
251: --,nvl(dem.planned_inbound_due_date , dem.using_assembly_demand_date) new_due_date
252: FROM msc_demands dem,
253: msc_plans mp,
254: msc_system_items msi ,
255: msc_item_categories mic
256: WHERE mic.sr_instance_id = dem.sr_instance_id

Line 289: FROM msc_demands dem,

285: p_from_date IN DATE,
286: p_to_date IN DATE ) IS
287: SELECT dem.demand_id transaction_id
288: --,nvl(dem.old_using_assembly_demand_date , dem.using_assembly_demand_date) new_due_date
289: FROM msc_demands dem,
290: msc_plans mp,
291: msc_system_items msi ,
292: msc_item_categories mic
293: WHERE mic.sr_instance_id = dem.sr_instance_id

Line 335: FROM msc_demands

331: CURSOR c_sd_49(p_plan_id NUMBER,
332: p_sr_instance_id NUMBER,
333: p_demand_id NUMBER) IS
334: SELECT demand_id
335: FROM msc_demands
336: WHERE plan_id = p_plan_id
337: AND sr_instance_id = p_sr_instance_id
338: AND group_id IN (SELECT group_id
339: FROM msc_demands

Line 339: FROM msc_demands

335: FROM msc_demands
336: WHERE plan_id = p_plan_id
337: AND sr_instance_id = p_sr_instance_id
338: AND group_id IN (SELECT group_id
339: FROM msc_demands
340: WHERE plan_id = p_plan_id
341: AND sr_instance_id = p_sr_instance_id
342: AND demand_id = p_demand_id);
343:

Line 348: msc_demands md

344: CURSOR c_demand_84 (p_plan_id NUMBER,
345: p_excp_id NUMBER) IS
346: SELECT md.demand_id
347: FROM msc_exception_details med,
348: msc_demands md
349: WHERE med.plan_id = md.plan_id
350: AND med.exception_type = 84
351: AND med.exception_detail_id = p_excp_id
352: AND med.plan_id = p_plan_id