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 215: FROM msc_safety_stocks mst,

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

Line 2248: available in msc_safety_stocks table till plan_end_date or horizon_end_date

2244: END IF; --the if loop directly inside the for loop for j.
2245:
2246: /*-------------------------------------------------------------------------------
2247: -- Bug# 3913477 : for levelling safety stock after last safety stock data
2248: available in msc_safety_stocks table till plan_end_date or horizon_end_date
2249: whichever ends first. The loop inserts data for MULTIORG case or MULTI_ITEM
2250: case whenever pub_id or pub_site_id( ORG_ID) or item_id changes.
2251: -------------------------------------------------------------------------------*/
2252: IF (j > 1 AND

Line 3024: in msc_safety_stocks table till plan_end_date or horizon_end_date

3020:
3021: END IF ; -----to end block
3022: /*-------------------------------------------------------------------------
3023: -- Bug# 3913477 : for levelling PAB after last PAB data available
3024: in msc_safety_stocks table till plan_end_date or horizon_end_date
3025: whichever ends first. The loop inserts data for MULTIORG , MULTI_ITEM case
3026: whenever pub_id or pub_site_id( ORG_ID) or item_id changes.
3027: -------------------------------------------------------------------------*/
3028: