[Home] [Help]
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
182: i.plan_id = ov.plan_id and
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
282: ov.sr_instance_id = NVL(p_sr_instance_id, ov.sr_instance_id) and
283: i.plan_id = ov.plan_id and
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
425: ov.sr_instance_id = NVL(p_sr_instance_id, ov.sr_instance_id) and
426: ov.plan_id = sup.plan_id and
523: from msc_plan_organizations_v ov,
524: msc_system_items i,
525: msc_demands dem,
526: msc_trading_partners t1,
527: msc_plan_buckets mpb
528: where ov.plan_id = p_plan_id and
529: ov.planned_organization = NVL(p_org_id, ov.planned_organization) and
530: ov.sr_instance_id = NVL(p_sr_instance_id, ov.sr_instance_id) and
531: ov.plan_id = dem.plan_id and