DBA Data[Home] [Help]

APPS.MSC_GANTT_PKG dependencies on MSC_SYSTEM_ITEMS

Line 281: msc_system_items msi

277: ms.source_supplier_id) start_date,
278: ms.order_type
279: from msc_form_query mfq,
280: msc_supplies ms,
281: msc_system_items msi
282: where mfq.query_id = x_dem_op_query_id
283: and mfq.number1 = x_supply_id
284: and ms.plan_id = x_plan_id
285: and ms.sr_instance_id = x_inst_id

Line 315: msc_system_items msi

311: from msc_full_pegging mfp1,
312: msc_full_pegging mfp2,
313: msc_form_query mfq,
314: msc_supplies ms,
315: msc_system_items msi
316: where mfp1.plan_id = x_plan_id
317: and mfp1.sr_instance_id = x_instance_id
318: and mfp1.transaction_id = x_supply_id
319: and mfq.query_id = x_end_peg_query_id

Line 360: msc_system_items msi

356: ms.order_type
357: from msc_full_pegging mfp1,
358: msc_full_pegging mfp2,
359: msc_supplies ms,
360: msc_system_items msi
361: where mfp1.plan_id = x_plan_id
362: and mfp1.sr_instance_id = x_instance_id
363: and mfp1.transaction_id = x_supply_id
364: and mfp2.plan_id = mfp1.plan_id

Line 396: msc_system_items msi

392: ms.order_type
393: from msc_full_pegging mfp1,
394: msc_full_pegging mfp2,
395: msc_supplies ms,
396: msc_system_items msi
397: where mfp1.plan_id = x_plan_id
398: and mfp1.sr_instance_id = x_instance_id
399: and mfp1.transaction_id = x_supply_id
400: and mfp2.plan_id = mfp1.plan_id