[Home] [Help]
272: ,cal2.calendar_date -- date also to print 10325294
273: FROM msc_calendar_dates cal1,
274: msc_calendar_dates cal2,
275: msc_planners mpl,
276: msc_trading_partners mparam,
277: msc_system_items msi,
278: msc_system_items rsi,
279: msc_supplies mr,
280: msc_plan_organizations_v mpo,
278: msc_system_items rsi,
279: msc_supplies mr,
280: msc_plan_organizations_v mpo,
281: msc_plans mps,
282: msc_trading_partners mt
283: WHERE -- mpo.organization_id = arg_org_id
284: mpo.plan_id = arg_plan_id
285: -- AND mpo.sr_instance_id = arg_instance_id
286: AND mr.sr_instance_id = mpo.sr_instance_id
440: ( NVL(mps.auto_release_method,-1) NOT IN (3,4) AND NVL(mr.releasable,0) =0 )-- other autorel
441: )
442: AND mr.batch_id is NULL
443: -- shikyu changes
444: AND not exists (select 1 from msc_system_items msi1 , msc_trading_partners mtp
445: where msi1.inventory_item_id = mr.inventory_item_id
446: and msi1.organization_id = mr.organization_id
447: and msi1.plan_id = mr.plan_id
448: AND msi1.sr_instance_id = mr.sr_instance_id
462: from
463: msc_supplies ms,
464: msc_plans mps,
465: msc_system_items msi,
466: msc_trading_partners mtp,
467: msc_calendar_dates cal1,
468: msc_calendar_dates cal2
469: where
470: ms.plan_id =arg_plan_id
512: from
513: msc_supplies ms,
514: msc_plans mps,
515: msc_system_items msi,
516: msc_trading_partners mtp,
517: msc_calendar_dates cal1,
518: msc_calendar_dates cal2
519: where
520: ms.plan_id =arg_plan_id
579: from
580: msc_supplies ms,
581: msc_plans mps,
582: msc_system_items msi,
583: msc_trading_partners mtp,
584: msc_calendar_dates cal1,
585: msc_calendar_dates cal2
586: where
587: ms.plan_id =arg_plan_id
1280: msi.item_name,
1281: msi.planner_code
1282: INTO var_org_code, var_item, var_planner_code
1283: FROM msc_system_items msi,
1284: msc_trading_partners param,
1285: msc_supplies mr
1286: WHERE mr.transaction_id = var_transaction_id
1287: AND mr.sr_instance_id = var_sr_instance_id
1288: AND mr.plan_id = var_plan_id