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 MRP_FORECAST_DATES

Line 71: FROM MRP_FORECAST_DESIGNATORS D, MRP_FORECAST_DATES F, MTL_SYSTEM_ITEMS MSI

67:
68: cursor ITEM1_cur IS
69: --Bug#2713829, also selected MRP_SAFETY_STOCK_PERCENT from MSI.
70: SELECT DISTINCT F.INVENTORY_ITEM_ID, MSI.MRP_SAFETY_STOCK_PERCENT
71: FROM MRP_FORECAST_DESIGNATORS D, MRP_FORECAST_DATES F, MTL_SYSTEM_ITEMS MSI
72: WHERE D.ORGANIZATION_ID = X_ORGANIZATION_ID AND
73: D.FORECAST_DESIGNATOR = X_FORECAST_NAME AND
74: D.ORGANIZATION_ID = F.ORGANIZATION_ID AND
75: D.FORECAST_DESIGNATOR = F.FORECAST_DESIGNATOR AND

Line 81: FROM MRP_FORECAST_DESIGNATORS D, MRP_FORECAST_DATES F,

77: MSI.INVENTORY_ITEM_ID = F.INVENTORY_ITEM_ID;
78:
79: cursor ITEM2_cur IS
80: SELECT DISTINCT F.INVENTORY_ITEM_ID
81: FROM MRP_FORECAST_DESIGNATORS D, MRP_FORECAST_DATES F,
82: MTL_ITEM_CATEGORIES C
83: WHERE D.ORGANIZATION_ID = X_ORGANIZATION_ID AND
84: D.FORECAST_DESIGNATOR = X_FORECAST_NAME AND
85: D.ORGANIZATION_ID = F.ORGANIZATION_ID AND

Line 99: EXISTS (SELECT 'X' FROM MRP_FORECAST_DATES f

95: FORECAST_DESIGNATOR
96: IN (SELECT d.FORECAST_DESIGNATOR
97: FROM MRP_FORECAST_DESIGNATORS d
98: WHERE d.ORGANIZATION_ID = X_ORGANIZATION_ID AND
99: EXISTS (SELECT 'X' FROM MRP_FORECAST_DATES f
100: WHERE f.INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID AND
101: d.FORECAST_DESIGNATOR = f.FORECAST_DESIGNATOR AND
102: ORGANIZATION_ID = X_ORGANIZATION_ID));
103:

Line 140: FROM MRP_FORECAST_DESIGNATORS D, MRP_FORECAST_DATES F

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
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 )

Line 156: AND NOT EXISTS ( SELECT 1 FROM MRP_FORECAST_DESIGNATORS D, MRP_FORECAST_DATES F

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
157: WHERE D.ORGANIZATION_ID = X_ORGANIZATION_ID
158: AND D.FORECAST_DESIGNATOR = X_FORECAST_NAME
159: AND D.ORGANIZATION_ID = F.ORGANIZATION_ID
160: AND D.FORECAST_DESIGNATOR = F.FORECAST_DESIGNATOR

Line 179: FROM MRP_FORECAST_DESIGNATORS D, MRP_FORECAST_DATES F,

175: AND C.CATEGORY_SET_ID = X_CATEGORY_SET_ID
176: AND C.CATEGORY_ID = X_CATEGORY_ID
177: AND C.ORGANIZATION_ID = X_ORGANIZATION_ID )
178: AND INVENTORY_ITEM_ID NOT IN ( SELECT DISTINCT F.INVENTORY_ITEM_ID
179: FROM MRP_FORECAST_DESIGNATORS D, MRP_FORECAST_DATES F,
180: MTL_ITEM_CATEGORIES C
181: WHERE D.ORGANIZATION_ID = X_ORGANIZATION_ID
182: AND D.FORECAST_DESIGNATOR = X_FORECAST_NAME
183: AND D.ORGANIZATION_ID = F.ORGANIZATION_ID

Line 367: MRP_FORECAST_DATES F

363: ROUND(SUM(NVL(F.FORECAST_MAD, 0)) * srv_factor, 5) -- 6797274 changes
364: FROM
365: BOM_CALENDAR_DATES C1,
366: MRP_FORECAST_DESIGNATORS D1,
367: MRP_FORECAST_DATES F
368: WHERE D1.ORGANIZATION_ID = org_id
369: AND D1.FORECAST_DESIGNATOR = forc_name
370: AND F.ORGANIZATION_ID = org_id
371: AND F.INVENTORY_ITEM_ID = item_id

Line 388: BOM_CAL_WEEK_START_DATES W1, MRP_FORECAST_DATES F,

384: ROUND(SUM(NVL(F.FORECAST_MAD, 0)/(C2.NEXT_SEQ_NUM - -- 6797274 changes
385: C3.NEXT_SEQ_NUM)) * srv_factor, 5)
386: FROM BOM_CALENDAR_DATES C1, BOM_CALENDAR_DATES C2,
387: BOM_CALENDAR_DATES C3,
388: BOM_CAL_WEEK_START_DATES W1, MRP_FORECAST_DATES F,
389: MRP_FORECAST_DESIGNATORS D1
390: WHERE D1.ORGANIZATION_ID = org_id
391: AND D1.FORECAST_DESIGNATOR = forc_name
392: AND F.ORGANIZATION_ID = org_id

Line 421: BOM_PERIOD_START_DATES W1, MRP_FORECAST_DATES F,

417: ROUND(SUM(NVL(F.FORECAST_MAD, 0)/(C2.NEXT_SEQ_NUM - -- 6797274 changes
418: C3.NEXT_SEQ_NUM)) * srv_factor, 5)
419: FROM BOM_CALENDAR_DATES C1, BOM_CALENDAR_DATES C2,
420: BOM_CALENDAR_DATES C3,
421: BOM_PERIOD_START_DATES W1, MRP_FORECAST_DATES F,
422: MRP_FORECAST_DESIGNATORS D1
423: WHERE D1.ORGANIZATION_ID = org_id
424: AND D1.FORECAST_DESIGNATOR = forc_name
425: AND F.ORGANIZATION_ID = org_id

Line 456: MRP_FORECAST_DATES F

452: ROUND(SUM(F.ORIGINAL_FORECAST_QUANTITY)* ss_percent/100 , 5)
453: FROM
454: BOM_CALENDAR_DATES C1,
455: MRP_FORECAST_DESIGNATORS D1,
456: MRP_FORECAST_DATES F
457: WHERE D1.ORGANIZATION_ID = org_id
458: AND D1.FORECAST_DESIGNATOR = forc_name
459: AND F.ORGANIZATION_ID = org_id
460: AND F.INVENTORY_ITEM_ID = item_id

Line 476: BOM_CAL_WEEK_START_DATES W1, MRP_FORECAST_DATES F,

472: ROUND(SUM(ORIGINAL_FORECAST_QUANTITY/
473: (C2.NEXT_SEQ_NUM - C3.NEXT_SEQ_NUM))* ss_percent/100 ,5)
474: FROM BOM_CALENDAR_DATES C1, BOM_CALENDAR_DATES C2,
475: BOM_CALENDAR_DATES C3,
476: BOM_CAL_WEEK_START_DATES W1, MRP_FORECAST_DATES F,
477: MRP_FORECAST_DESIGNATORS D1
478: WHERE D1.ORGANIZATION_ID = org_id
479: AND D1.FORECAST_DESIGNATOR = forc_name
480: AND F.ORGANIZATION_ID = org_id

Line 508: BOM_PERIOD_START_DATES W1, MRP_FORECAST_DATES F,

504: ROUND(SUM(ORIGINAL_FORECAST_QUANTITY/
505: (C2.NEXT_SEQ_NUM - C3.NEXT_SEQ_NUM))* ss_percent/100 ,5)
506: FROM BOM_CALENDAR_DATES C1, BOM_CALENDAR_DATES C2,
507: BOM_CALENDAR_DATES C3,
508: BOM_PERIOD_START_DATES W1, MRP_FORECAST_DATES F,
509: MRP_FORECAST_DESIGNATORS D1
510: WHERE D1.ORGANIZATION_ID = org_id
511: AND D1.FORECAST_DESIGNATOR = forc_name
512: AND F.ORGANIZATION_ID = org_id

Line 623: /* are selected from the MRP_FORECAST_DATES. */

619: /********************************************************/
620: /* In contrast to the pro_sdate and pro_sqty, pro_fdate */
621: /* and pro_fqty are defined as the processing forecast */
622: /* qty and date respetively. The forecast qty and date */
623: /* are selected from the MRP_FORECAST_DATES. */
624: /* Initialize the pro_fdate and pro_fqty. */
625: /* pro_fdate <- effect_date */
626: /* pro_fqty <- 0 */
627: /* */