DBA Data[Home] [Help]

APPS.MSC_SCE_PUBLISH_PKG dependencies on MSC_SUPPLIES

Line 174: msc_supplies sup,

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

Line 274: msc_supplies sup,

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

Line 417: msc_supplies sup,

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