DBA Data[Home] [Help]

APPS.MSC_SCE_PUBLISH_PKG dependencies on MSC_SUPPLIES

Line 177: msc_supplies sup,

173: msc_calendar.DATE_OFFSET(sup.organization_id,sup.sr_instance_id, 1,sup.firm_date, - nvl(i.postprocessing_lead_time,0))
174: ) --reciept_date
175: from msc_plan_organizations_v ov,
176: msc_system_items i,
177: msc_supplies sup,
178: msc_plan_buckets mpb
179: where ov.plan_id = p_plan_id and
180: ov.planned_organization = NVL(p_org_id, ov.planned_organization) and
181: ov.sr_instance_id = NVL(p_sr_instance_id, ov.sr_instance_id) and

Line 277: msc_supplies sup,

273: msc_calendar.DATE_OFFSET(sup.organization_id,sup.sr_instance_id, 1,sup.firm_date, - nvl(i.postprocessing_lead_time,0))
274: ) --reciept_date
275: from msc_plan_organizations_v ov,
276: msc_system_items i,
277: msc_supplies sup,
278: msc_trading_partners t1,
279: msc_plan_buckets mpb
280: where ov.plan_id = p_plan_id and
281: ov.planned_organization = NVL(p_org_id, ov.planned_organization) and

Line 420: msc_supplies sup,

416: sup.order_number order_number, -- use only for intransit_shipment_def and intransit_receipt_def
417: NULL line_number -- dummy type not to be used
418: from msc_plan_organizations_v ov,
419: msc_system_items i,
420: msc_supplies sup,
421: msc_trading_partners t1,
422: msc_plan_buckets mpb
423: where ov.plan_id = p_plan_id and
424: ov.planned_organization = NVL(p_org_id, ov.planned_organization) and