DBA Data[Home] [Help]

APPS.MSC_SCE_PUBLISH_PKG dependencies on MSC_PLAN_BUCKETS

Line 175: msc_plan_buckets mpb

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
179: i.plan_id = ov.plan_id and

Line 276: msc_plan_buckets mpb

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
279: ov.sr_instance_id = NVL(p_sr_instance_id, ov.sr_instance_id) and
280: i.plan_id = ov.plan_id and

Line 419: msc_plan_buckets mpb

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
422: ov.sr_instance_id = NVL(p_sr_instance_id, ov.sr_instance_id) and
423: ov.plan_id = sup.plan_id and

Line 524: msc_plan_buckets mpb

520: from msc_plan_organizations_v ov,
521: msc_system_items i,
522: msc_demands dem,
523: msc_trading_partners t1,
524: msc_plan_buckets mpb
525: where ov.plan_id = p_plan_id and
526: ov.planned_organization = NVL(p_org_id, ov.planned_organization) and
527: ov.sr_instance_id = NVL(p_sr_instance_id, ov.sr_instance_id) and
528: ov.plan_id = dem.plan_id and