[Home] [Help]
249: nvl(mr.implement_project_id,mr.project_id)
250: FROM msc_calendar_dates cal1,
251: msc_calendar_dates cal2,
252: msc_planners mpl,
253: msc_trading_partners mparam,
254: msc_system_items msi,
255: msc_system_items rsi,
256: msc_supplies mr,
257: msc_plan_organizations_v mpo,
255: msc_system_items rsi,
256: msc_supplies mr,
257: msc_plan_organizations_v mpo,
258: msc_plans mps,
259: msc_trading_partners mt
260: WHERE mpo.organization_id = arg_org_id
261: AND mpo.plan_id = arg_plan_id
262: AND mpo.sr_instance_id = arg_instance_id
263: AND mr.sr_instance_id = mpo.sr_instance_id
389: AND mt.partner_type(+) = 3
390: AND (mr.releasable = MSC_Rel_Plan_PUB.RELEASABLE or mr.releasable is null )
391: AND mr.batch_id is NULL
392: -- shikyu changes
393: AND not exists (select 1 from msc_system_items msi1 , msc_trading_partners mtp
394: where msi1.inventory_item_id = mr.inventory_item_id
395: and msi1.organization_id = mr.organization_id
396: and msi1.plan_id = mr.plan_id
397: AND msi1.sr_instance_id = mr.sr_instance_id
410: ms.plan_id
411: from
412: msc_supplies ms,
413: msc_system_items msi,
414: msc_trading_partners mtp,
415: msc_calendar_dates cal1,
416: msc_calendar_dates cal2
417: where
418: ms.plan_id =arg_plan_id
454: ms.plan_id
455: from
456: msc_supplies ms,
457: msc_system_items msi,
458: msc_trading_partners mtp,
459: msc_calendar_dates cal1,
460: msc_calendar_dates cal2
461: where
462: ms.plan_id =arg_plan_id
1018: msi.item_name,
1019: msi.planner_code
1020: INTO var_org_code, var_item, var_planner_code
1021: FROM msc_system_items msi,
1022: msc_trading_partners param,
1023: msc_supplies mr
1024: WHERE mr.transaction_id = var_transaction_id
1025: AND mr.sr_instance_id = var_sr_instance_id
1026: AND mr.plan_id = var_plan_id