APPS.MRP_EXCEPTIONS_SC_PK dependencies on MRP_FORM_QUERY

Line 17: /* Insert one row into mrp_form_query for each exception type:

13: BEGIN
14:
15: /* $Header: MRPPEPKB.pls 115.0 99/07/16 12:32:12 porting ship $ */
16:
17: /* Insert one row into mrp_form_query for each exception type:
18: 1 - Items that are over-committed
19: 2 - Items with a shortage
20: 3 - Items with excess inventory
21: 4 - Items with repetitive variance

Line 38: INSERT INTO mrp_form_query

34: raised the exception.
35: */
36:
37: IF p_planner is NULL THEN
38: INSERT INTO mrp_form_query
39: (query_id,
40: last_update_date,
41: last_updated_by,
42: creation_date,

Line 85: UPDATE mrp_form_query q

81: /*------------------------------------+
82: | Update the number3 column to the |
83: | numbers orders having the exception |
84: +------------------------------------*/
85: UPDATE mrp_form_query q
86: SET number3 = /* number of orders */
87: (SELECT COUNT(r.organization_id)
88: FROM mrp_recommendations r,
89: mrp_item_exceptions e,

Line 124: INSERT INTO mrp_form_query

120: AND q.query_id = p_query_id
121: AND q.number1 IN (6, 7, 8, 9, 10);
122:
123: ELSE
124: INSERT INTO mrp_form_query
125: (query_id,
126: last_update_date,
127: last_updated_by,
128: creation_date,

Line 176: UPDATE mrp_form_query q

172: | Update the number3 column to the |
173: | numbers orders having the exception |
174: +------------------------------------*/
175:
176: UPDATE mrp_form_query q
177: SET number3 = /* number of orders */
178: (select COUNT(r.organization_id)
179: FROM mrp_recommendations r,
180: mrp_item_exceptions e,