eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_RELEASE_PK dependencies on MSC_SYSTEM_ITEMS

Line 277: msc_system_items msi,

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,
281: msc_plans mps,

Line 278: msc_system_items rsi,

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,
281: msc_plans mps,
282: msc_trading_partners mt

Line 337: select a.transaction_id from msc_supplies a, msc_supplies b,MSC_DESIGNATORS d, msc_system_items e

333: AND rsi.inventory_item_id = mr.inventory_item_id
334: AND ( NVL(rsi.in_source_plan, 2) <> 1
335: OR
336: mr.transaction_id in (
337: select a.transaction_id from msc_supplies a, msc_supplies b,MSC_DESIGNATORS d, msc_system_items e
338: where a.schedule_designator_id is not null
339: and a.schedule_designator_id = b.schedule_designator_id
340: and a.organization_id = mr.organization_id
341: and a.organization_id = b.organization_id

Line 444: AND not exists (select 1 from msc_system_items msi1 , msc_trading_partners mtp

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

Line 465: msc_system_items msi,

461: ms.plan_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

Line 515: msc_system_items msi,

511: ms.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

Line 582: msc_system_items msi,

578: ms.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

Line 1283: FROM msc_system_items msi,

1279: SELECT param.organization_code,
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