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.MRP_MRPRPROP_XMLP_PKG dependencies on MTL_SAFETY_STOCKS

Line 207: MTL_SAFETY_STOCKS S1

203: NVL(MAX(S1.SAFETY_STOCK_QUANTITY)
204: ,0)
205: INTO SAFETY_STOCK
206: FROM
207: MTL_SAFETY_STOCKS S1
208: WHERE S1.ORGANIZATION_ID = P_ORG_ID
209: AND S1.INVENTORY_ITEM_ID = C_ITEM_ID
210: AND ( S1.EFFECTIVITY_DATE <= ( sysdate + C_ORD_LEAD_TIME )
211: AND S1.EFFECTIVITY_DATE >= (

Line 216: MTL_SAFETY_STOCKS S2

212: SELECT
213: NVL(MAX(S2.EFFECTIVITY_DATE)
214: ,SYSDATE)
215: FROM
216: MTL_SAFETY_STOCKS S2
217: WHERE S2.ORGANIZATION_ID = P_ORG_ID
218: AND S2.INVENTORY_ITEM_ID = C_ITEM_ID
219: AND S2.EFFECTIVITY_DATE <= sysdate ) );
220: RETURN (SAFETY_STOCK);