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 254: msc_system_items msi,

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

Line 255: msc_system_items rsi,

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,
258: msc_plans mps,
259: msc_trading_partners mt

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

309: AND rsi.inventory_item_id = mr.inventory_item_id
310: AND ( NVL(rsi.in_source_plan, 2) <> 1
311: OR
312: mr.transaction_id in (
313: select a.transaction_id from msc_supplies a, msc_supplies b,MSC_DESIGNATORS d, msc_system_items e
314: where a.schedule_designator_id is not null
315: and a.schedule_designator_id = b.schedule_designator_id
316: and a.organization_id = mr.organization_id
317: and a.organization_id = b.organization_id

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

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

Line 413: msc_system_items msi,

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

Line 457: msc_system_items msi,

453: ms.sr_instance_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

Line 1021: FROM msc_system_items msi,

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