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

Line 1: PACKAGE BODY MTL_SAFETY_STOCKS_PKG as

1: PACKAGE BODY MTL_SAFETY_STOCKS_PKG as
2: /* $Header: INVDDFSB.pls 120.6.12020000.2 2012/07/09 08:05:15 asugandh ship $ */
3:
4:
5: /****************************************************************

Line 24: FROM mtl_safety_stocks

20: SELECT 1
21: INTO l_num
22: FROM dual
23: WHERE EXISTS (SELECT 1
24: FROM mtl_safety_stocks
25: WHERE organization_id = p_organization_id
26: AND inventory_item_id = p_inventory_item_id
27: AND effectivity_date >= p_effect_date
28: AND (project_id IS NOT NULL OR task_id IS NOT NULL)

Line 136: DELETE FROM MTL_SAFETY_STOCKS M

132: -- Bug 5041094 Deleting the safety stock entries existing for forecast specified
133: -- when those items no longer exist on forecast but are selected by
134: -- item filter , but skipping items for which project/task level entries exist
135: IF (X_SELECTION = 1) THEN
136: DELETE FROM MTL_SAFETY_STOCKS M
137: WHERE ORGANIZATION_ID = X_ORGANIZATION_ID
138: AND FORECAST_DESIGNATOR = X_FORECAST_NAME
139: AND INVENTORY_ITEM_ID NOT IN ( SELECT DISTINCT F.INVENTORY_ITEM_ID
140: FROM MRP_FORECAST_DESIGNATORS D, MRP_FORECAST_DATES F

Line 145: AND NOT EXISTS ( SELECT 1 FROM MTL_SAFETY_STOCKS

141: WHERE D.ORGANIZATION_ID = X_ORGANIZATION_ID
142: AND D.FORECAST_DESIGNATOR = X_FORECAST_NAME
143: AND D.ORGANIZATION_ID = F.ORGANIZATION_ID
144: AND D.FORECAST_DESIGNATOR = F.FORECAST_DESIGNATOR )
145: AND NOT EXISTS ( SELECT 1 FROM MTL_SAFETY_STOCKS
146: WHERE ORGANIZATION_ID = M.ORGANIZATION_ID
147: AND INVENTORY_ITEM_ID = M.INVENTORY_ITEM_ID
148: AND EFFECTIVITY_DATE >= X_START_DATE
149: AND (PROJECT_ID IS NOT NULL OR TASK_ID IS NOT NULL))

Line 152: DELETE FROM MTL_SAFETY_STOCKS M

148: AND EFFECTIVITY_DATE >= X_START_DATE
149: AND (PROJECT_ID IS NOT NULL OR TASK_ID IS NOT NULL))
150: AND EFFECTIVITY_DATE >= X_START_DATE ;
151: ELSIF ( X_SELECTION = 2 ) THEN
152: DELETE FROM MTL_SAFETY_STOCKS M
153: WHERE ORGANIZATION_ID = X_ORGANIZATION_ID
154: AND FORECAST_DESIGNATOR = X_FORECAST_NAME
155: AND INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID
156: AND NOT EXISTS ( SELECT 1 FROM MRP_FORECAST_DESIGNATORS D, MRP_FORECAST_DATES F

Line 162: AND NOT EXISTS ( SELECT 1 FROM MTL_SAFETY_STOCKS

158: AND D.FORECAST_DESIGNATOR = X_FORECAST_NAME
159: AND D.ORGANIZATION_ID = F.ORGANIZATION_ID
160: AND D.FORECAST_DESIGNATOR = F.FORECAST_DESIGNATOR
161: AND F.INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID )
162: AND NOT EXISTS ( SELECT 1 FROM MTL_SAFETY_STOCKS
163: WHERE ORGANIZATION_ID = M.ORGANIZATION_ID
164: AND INVENTORY_ITEM_ID = M.INVENTORY_ITEM_ID
165: AND EFFECTIVITY_DATE >= X_START_DATE
166: AND (PROJECT_ID IS NOT NULL OR TASK_ID IS NOT NULL))

Line 169: DELETE FROM MTL_SAFETY_STOCKS M

165: AND EFFECTIVITY_DATE >= X_START_DATE
166: AND (PROJECT_ID IS NOT NULL OR TASK_ID IS NOT NULL))
167: AND EFFECTIVITY_DATE >= X_START_DATE ;
168: ELSE
169: DELETE FROM MTL_SAFETY_STOCKS M
170: WHERE ORGANIZATION_ID = X_ORGANIZATION_ID
171: AND FORECAST_DESIGNATOR = X_FORECAST_NAME
172: AND EXISTS ( SELECT 1 FROM MTL_ITEM_CATEGORIES C
173: WHERE C.ORGANIZATION_ID = M.ORGANIZATION_ID

Line 189: AND NOT EXISTS ( SELECT 1 FROM MTL_SAFETY_STOCKS

185: AND C.CATEGORY_SET_ID = X_CATEGORY_SET_ID
186: AND C.CATEGORY_ID = X_CATEGORY_ID
187: AND C.ORGANIZATION_ID = X_ORGANIZATION_ID
188: AND C.INVENTORY_ITEM_ID = F.INVENTORY_ITEM_ID )
189: AND NOT EXISTS ( SELECT 1 FROM MTL_SAFETY_STOCKS
190: WHERE ORGANIZATION_ID = M.ORGANIZATION_ID
191: AND INVENTORY_ITEM_ID = M.INVENTORY_ITEM_ID
192: AND EFFECTIVITY_DATE >= X_START_DATE
193: AND (PROJECT_ID IS NOT NULL OR TASK_ID IS NOT NULL))

Line 543: FROM MTL_SAFETY_STOCKS

539: WHERE FORECAST_DESIGNATOR = cp_forecast;
540:
541: CURSOR QTY_cur IS
542: SELECT SAFETY_STOCK_QUANTITY
543: FROM MTL_SAFETY_STOCKS
544: WHERE ORGANIZATION_ID = org_id
545: AND INVENTORY_ITEM_ID = item_id
546: AND EFFECTIVITY_DATE = (
547: SELECT MAX(EFFECTIVITY_DATE)

Line 548: FROM MTL_SAFETY_STOCKS

544: WHERE ORGANIZATION_ID = org_id
545: AND INVENTORY_ITEM_ID = item_id
546: AND EFFECTIVITY_DATE = (
547: SELECT MAX(EFFECTIVITY_DATE)
548: FROM MTL_SAFETY_STOCKS
549: WHERE ORGANIZATION_ID = org_id
550: AND INVENTORY_ITEM_ID = item_id
551: AND EFFECTIVITY_DATE < effect_date);
552:

Line 605: DELETE FROM MTL_SAFETY_STOCKS

601: /* Delete all the records since the effect_date, and */
602: /* prepare to reload them. */
603: /********************************************************/
604:
605: DELETE FROM MTL_SAFETY_STOCKS
606: WHERE ORGANIZATION_ID = org_id
607: AND INVENTORY_ITEM_ID = item_id
608: AND EFFECTIVITY_DATE >= effect_date;
609:

Line 616: /* exit will insert one row into the MTL_SAFETY_STOCKS */

612: /* The following opens the cursor and select the */
613: /* forecast results into the variables. */
614: /* If there is no row selected, it implies that there */
615: /* is no forecast qty. In this case, the user */
616: /* exit will insert one row into the MTL_SAFETY_STOCKS */
617: /* table (ie, qty = 0 and effectivety_date). */
618: /********************************************************/
619: /********************************************************/
620: /* In contrast to the pro_sdate and pro_sqty, pro_fdate */

Line 664: DELETE FROM MTL_SAFETY_STOCKS

660: IF ss_code = 3 and l_mad_calc THEN -- 6797274 changes
661:
662: /* Added the below query for bug # 10387262 and prepare to reload them.*/
663:
664: DELETE FROM MTL_SAFETY_STOCKS
665: WHERE ORGANIZATION_ID = org_id
666: AND INVENTORY_ITEM_ID = item_id
667: AND EFFECTIVITY_DATE >= to_date(forc_date,'J');
668:

Line 786: INSERT INTO MTL_SAFETY_STOCKS(

782:
783:
784:
785: BEGIN
786: INSERT INTO MTL_SAFETY_STOCKS(
787: EFFECTIVITY_DATE,SAFETY_STOCK_QUANTITY,
788: SAFETY_STOCK_PERCENT, LAST_UPDATE_DATE,
789: SERVICE_LEVEL, CREATION_DATE, LAST_UPDATED_BY,
790: CREATED_BY, LAST_UPDATE_LOGIN, ORGANIZATION_ID,

Line 897: END MTL_SAFETY_STOCKS_PKG;

893: return(safety_factor);
894: END CalSF;
895:
896:
897: END MTL_SAFETY_STOCKS_PKG;