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_MANAGER_PK dependencies on MRP_FORM_QUERY

Line 14: SELECT mrp_form_query_s.nextval

10: arg_request_id IN NUMBER,
11: arg_user_id IN NUMBER) IS
12: var_batch_id NUMBER;
13: BEGIN
14: SELECT mrp_form_query_s.nextval
15: INTO var_batch_id
16: FROM dual;
17:
18: var_watch_id := mrp_print_pk.start_watch(

Line 26: 'mrp_form_query(1:'||to_char(var_batch_id)||')',

22: 'ENTITY',
23: 'E_ITEMS',
24: 'Y',
25: 'TABLE',
26: 'mrp_form_query(1:'||to_char(var_batch_id)||')',
27: 'N');
28:
29: --
30: -- Insert the following into MRP_FORM_QUERY:

Line 30: -- Insert the following into MRP_FORM_QUERY:

26: 'mrp_form_query(1:'||to_char(var_batch_id)||')',
27: 'N');
28:
29: --
30: -- Insert the following into MRP_FORM_QUERY:
31: -- 1. Items in MRP_RELIEF_INTERFACE
32: -- 2. Product family of items in (1)
33: -- 3. Components of config items in (1)
34: -- 4. Other items that are in the same product family as items in (1)

Line 36: INSERT INTO mrp_form_query (

32: -- 2. Product family of items in (1)
33: -- 3. Components of config items in (1)
34: -- 4. Other items that are in the same product family as items in (1)
35: --
36: INSERT INTO mrp_form_query (
37: query_id,
38: number1,
39: number2,
40: number3,

Line 141: 'mrp_form_query(2:'||to_char(var_batch_id)||')',

137: 'ENTITY',
138: 'E_ITEMS',
139: 'Y',
140: 'TABLE',
141: 'mrp_form_query(2:'||to_char(var_batch_id)||')',
142: 'N');
143:
144: --
145: -- Insert the config items of those items inserted above

Line 147: INSERT INTO mrp_form_query (

143:
144: --
145: -- Insert the config items of those items inserted above
146: --
147: INSERT INTO mrp_form_query (
148: query_id,
149: number1,
150: number2,
151: number3,

Line 169: mrp_form_query query

165: FROM mtl_system_items bom_item,
166: bom_bill_of_materials bom,
167: bom_inventory_components comp,
168: mtl_system_items comp_item,
169: mrp_form_query query
170: WHERE bom_item.base_item_id IS NOT NULL
171: AND bom_item.organization_id = bom.organization_id
172: AND bom_item.inventory_item_id = bom.assembly_item_id
173: AND bom.alternate_bom_designator IS NULL

Line 198: SELECT mrp_form_query_s.nextval

194: var_batch_id NUMBER;
195: var_batch_size NUMBER;
196: var_expl NUMBER;
197: BEGIN
198: SELECT mrp_form_query_s.nextval
199: INTO var_batch_id
200: FROM dual;
201:
202: var_watch_id := mrp_print_pk.start_watch(

Line 210: 'mrp_form_query(1:'||to_char(var_batch_id)||')',

206: 'ENTITY',
207: 'E_ITEMS',
208: 'Y',
209: 'TABLE',
210: 'mrp_form_query(1:'||to_char(var_batch_id)||')',
211: 'N');
212:
213: var_expl := NVL(TO_NUMBER(FND_PROFILE.VALUE('MRP_FC_EXPLOSION')), SYS_YES);
214: var_batch_size := NVL(TO_NUMBER(FND_PROFILE.VALUE(

Line 218: -- Insert the following into MRP_FORM_QUERY:

214: var_batch_size := NVL(TO_NUMBER(FND_PROFILE.VALUE(
215: 'MRP_SCHED_MGR_BATCH_SIZE')), SYS_YES);
216:
217: --
218: -- Insert the following into MRP_FORM_QUERY:
219: -- 1. Items in MRP_SALES_ORDER_UPDATES
220: -- 2. Product family of items in (1)
221: -- 3. Components of items in (1)
222: -- 4. Other items that are in the same product family as items in (1)

Line 224: INSERT INTO mrp_form_query (

220: -- 2. Product family of items in (1)
221: -- 3. Components of items in (1)
222: -- 4. Other items that are in the same product family as items in (1)
223: --
224: INSERT INTO mrp_form_query (
225: query_id,
226: number1,
227: number2,
228: number3,

Line 340: 'mrp_form_query(2:'||to_char(var_batch_id)||')',

336: 'ENTITY',
337: 'E_ITEMS',
338: 'Y',
339: 'TABLE',
340: 'mrp_form_query(2:'||to_char(var_batch_id)||')',
341: 'N');
342:
343: --
344: -- Insert the following into MRP_FORM_QUERY:

Line 344: -- Insert the following into MRP_FORM_QUERY:

340: 'mrp_form_query(2:'||to_char(var_batch_id)||')',
341: 'N');
342:
343: --
344: -- Insert the following into MRP_FORM_QUERY:
345: -- 1. Model and Option classes of mandatory standard items
346: -- which are inserted above
347: -- 2. Config items of those items inserted above
348: --

Line 349: INSERT INTO mrp_form_query (

345: -- 1. Model and Option classes of mandatory standard items
346: -- which are inserted above
347: -- 2. Config items of those items inserted above
348: --
349: INSERT INTO mrp_form_query (
350: query_id,
351: number1,
352: number2,
353: number3,

Line 358: SELECT /*+ INDEX (query MRP_FORM_QUERY_N1)

354: last_update_date,
355: last_updated_by,
356: creation_date,
357: created_by)
358: SELECT /*+ INDEX (query MRP_FORM_QUERY_N1)
359: ORDERED
360: USE_NL (query, comp_item, comp, bom, bom_item) */
361: DISTINCT
362: var_batch_id,

Line 370: FROM mrp_form_query query,

366: SYSDATE,
367: -1,
368: SYSDATE,
369: -1
370: FROM mrp_form_query query,
371: mtl_system_items comp_item,
372: bom_inventory_components comp,
373: bom_bill_of_materials bom,
374: mtl_system_items bom_item

Line 409: 'mrp_form_query(3:'||to_char(var_batch_id)||')',

405: 'ENTITY',
406: 'E_ITEMS',
407: 'Y',
408: 'TABLE',
409: 'mrp_form_query(3:'||to_char(var_batch_id)||')',
410: 'N');
411: --
412: -- Inserting the records to process
413: --

Line 414: INSERT INTO mrp_form_query (

410: 'N');
411: --
412: -- Inserting the records to process
413: --
414: INSERT INTO mrp_form_query (
415: query_id,
416: number1,
417: number2,
418: number3,

Line 460: FROM mrp_form_query

456: AND upd2.request_id IS NULL
457: AND rownum <= var_batch_size
458: AND NOT EXISTS
459: (SELECT 'x'
460: FROM mrp_form_query
461: WHERE query_id = var_batch_id
462: AND number1 = upd2.inventory_item_id);
463:
464: mrp_print_pk.stop_watch(arg_request_id,