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_PUBLISH_SAFETY_STOCK_PKG dependencies on MSC_SAFETY_STOCKS

Line 212: FROM msc_safety_stocks mst,

208: NULL, --mst.planning_group,
209: NULL, --mst.project_id,
210: NULL, --mst.task_id,
211: sum(mst.safety_stock_quantity)
212: FROM msc_safety_stocks mst,
213: msc_plan_buckets mpb,
214: msc_plan_organizations_v ov,
215: msc_system_items item,
216: msc_companies c,

Line 2232: available in msc_safety_stocks table till plan_end_date or horizon_end_date

2228: END IF; --the if loop directly inside the for loop for j.
2229:
2230: /*-------------------------------------------------------------------------------
2231: -- Bug# 3913477 : for levelling safety stock after last safety stock data
2232: available in msc_safety_stocks table till plan_end_date or horizon_end_date
2233: whichever ends first. The loop inserts data for MULTIORG case or MULTI_ITEM
2234: case whenever pub_id or pub_site_id( ORG_ID) or item_id changes.
2235: -------------------------------------------------------------------------------*/
2236: IF (j > 1 AND

Line 3008: in msc_safety_stocks table till plan_end_date or horizon_end_date

3004:
3005: END IF ; -----to end block
3006: /*-------------------------------------------------------------------------
3007: -- Bug# 3913477 : for levelling PAB after last PAB data available
3008: in msc_safety_stocks table till plan_end_date or horizon_end_date
3009: whichever ends first. The loop inserts data for MULTIORG , MULTI_ITEM case
3010: whenever pub_id or pub_site_id( ORG_ID) or item_id changes.
3011: -------------------------------------------------------------------------*/
3012: