DBA Data[Home] [Help]

APPS.MSC_PQ_UTILS dependencies on MSC_SUPPLIES

Line 101: FROM msc_supplies sup,

97: p_from_date IN DATE,
98: p_to_date IN DATE ) IS
99: SELECT sup.transaction_id
100: --,sup.new_schedule_date new_due_date
101: FROM msc_supplies sup,
102: msc_system_items msi ,
103: msc_item_categories mic
104: WHERE mic.sr_instance_id = sup.sr_instance_id
105: AND mic.organization_id = sup.organization_id

Line 219: FROM msc_supplies sup,

215: p_from_date IN DATE,
216: p_to_date IN DATE ) IS
217: SELECT sup.transaction_id
218: --,nvl(sup.new_ship_date,sup.new_schedule_date) new_due_date
219: FROM msc_supplies sup,
220: msc_system_items msi ,
221: msc_item_categories mic,
222: msc_plans mp
223: WHERE mic.sr_instance_id = sup.sr_instance_id

Line 420: msc_supplies s,

416: p_from_date DATE,
417: p_to_date DATE) IS
418: SELECT supply_id
419: FROM msc_resource_requirements r,
420: msc_supplies s,
421: msc_system_items i
422: WHERE r.plan_id = p_plan_id
423: AND r.sr_instance_id = p_inst_id
424: AND r.organization_id = p_org_id