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.ENG_NEW_ITEM_REQ_UTIL dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 328: from mtl_system_items_interface msii

324: (select change_order_type_id from eng_change_order_types where TYPE_CLASSIFICATION='LINE'
325: AND CHANGE_MGMT_TYPE_CODE = 'NEW_ITEM_REQUEST' AND ROWNUM=1) change_type_id,
326: 1 status_code,
327: 1 APPROVAL_STATUS_TYPE
328: from mtl_system_items_interface msii
329: where msii.set_process_id = p_batch_id
330: and msii.process_flag = l_process_flag
331: -- and msii.transaction_type=L_TRANSACTION_TYPE
332: ;

Line 345: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,

341: msii.organization_id
342: bulk collect INTO l_icc_array ,
343: l_change_type_array,
344: l_org_array
345: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
346: MTL_ITEM_CATALOG_GROUPS_VL micg,
347: ENG_CHANGE_ORDER_TYPES_VL eng_types,
348: MTL_PARAMETERS mp
349: WHERE msii.set_process_id=P_BATCH_ID

Line 382: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,

378: msii.organization_id
379: BULK COLLECT INTO l_icc_array ,
380: l_change_type_array,
381: l_org_array
382: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
383: ENG_CHANGE_ORDER_TYPES_VL eng_types,
384: MTL_PARAMETERS mp,
385: ego_item_cat_denorm_hier heir,
386: mtl_item_catalog_groups_b micgb

Line 425: update mtl_system_items_interface msii

421: batch_id => p_batch_id) ;
422:
423: if l_return_status = 'G'
424: then
425: update mtl_system_items_interface msii
426: set process_flag= 3
427: where msii.set_process_id = P_BATCH_ID
428: AND PROCESS_FLAG = l_process_flag
429: AND msii.ITEM_CATALOG_GROUP_ID = l_icc_array(i)

Line 435: from mtl_system_items_interface msii

431: ;
432:
433: select transaction_id
434: bulk collect into l_transaction_array
435: from mtl_system_items_interface msii
436: where msii.set_process_id = P_BATCH_ID
437: AND PROCESS_FLAG = 3
438: AND msii.ITEM_CATALOG_GROUP_ID = l_icc_array(i)
439: -- AND msii.TRANSACTION_TYPE = L_TRANSACTION_TYPE

Line 453: ,'MTL_SYSTEM_ITEMS_INTERFACE'

449: FND_GLOBAL.CONC_REQUEST_ID
450: ,l_transaction_array(i) -- Row specific
451: ,l_err_text -- This is a dummy variable, if u want to pass message text and not name, assign the text to it
452: ,'ITEM_NUMBER' -- Column Name on which error occured
453: ,'MTL_SYSTEM_ITEMS_INTERFACE'
454: ,'INV_IOI_NO_AUTO_NIR' -- Message Name, If u want to specify the text directly, pass this as 'INV_IOI_ERR'
455: ,l_error_text);
456: END LOOP;
457: -- x_return_status := 'S';

Line 466: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

462:
463: END IF;
464: END LOOP;
465: forall count IN l_change_ids_array.FIRST .. l_change_ids_array.LAST
466: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
467: set change_id = l_change_ids_array(count)
468: WHERE ITEM_CATALOG_GROUP_ID = l_icc_array(count)
469: AND ORGANIZATION_ID = l_org_array(count)
470: AND set_process_id = p_batch_id

Line 491: FROM MTL_SYSTEM_ITEMS_INTERFACE

487: end if;
488: l_change_ids_array := NIR_CHANGE_TABLE();
489: select inventory_item_id ,transaction_id
490: bulk collect into l_item_ids_array,l_transaction_array
491: FROM MTL_SYSTEM_ITEMS_INTERFACE
492: where ITEM_CATALOG_GROUP_ID = l_icc_array(i)
493: AND ORGANIZATION_ID = l_org_array(i)
494: AND set_process_id = p_batch_id
495: AND PROCESS_FLAG = l_process_flag

Line 524: ,'MTL_SYSTEM_ITEMS_INTERFACE'

520: FND_GLOBAL.CONC_REQUEST_ID
521: ,l_transaction_array(i) -- Row specific
522: ,l_err_text -- This is a dummy variable, if u want to pass message text and not name, assign the text to it
523: ,'ITEM_NUMBER' -- Column Name on which error occured
524: ,'MTL_SYSTEM_ITEMS_INTERFACE'
525: ,'INV_IOI_NO_AUTO_NIR' -- Message Name, If u want to specify the text directly, pass this as 'INV_IOI_ERR'
526: ,l_error_text);
527:
528: else

Line 535: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

531: end if;
532: END LOOP;
533:
534: forall count in l_change_ids_array.FIRST .. l_change_ids_array.LAST
535: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
536: set change_id = l_change_ids_array(count)
537: WHERE ITEM_CATALOG_GROUP_ID = l_icc_array(i)
538: AND ORGANIZATION_ID = l_org_array(i)
539: AND set_process_id = p_batch_id

Line 547: update mtl_system_items_interface msii

543: END LOOP;
544:
545: END IF;
546:
547: update mtl_system_items_interface msii
548: set change_line_id = ENG_CHANGE_LINES_S.nextval
549: where msii.set_process_id = p_batch_id
550: and msii.process_flag= l_process_flag
551: -- and msii.transaction_type=L_TRANSACTION_TYPE

Line 582: from mtl_system_items_interface msii

578: (select change_order_type_id from eng_change_order_types where TYPE_CLASSIFICATION='LINE'
579: AND CHANGE_MGMT_TYPE_CODE = 'NEW_ITEM_REQUEST' AND ROWNUM=1) TYPE_ID,
580: 1 ,
581: 1
582: from mtl_system_items_interface msii
583: where msii.set_process_id = p_batch_id
584: and msii.process_flag = l_process_flag
585: -- and msii.transaction_type=L_TRANSACTION_TYPE
586: );

Line 643: from mtl_system_items_interface msii,

639: FND_GLOBAL.USER_ID,
640: LANGS.LANGUAGE_CODE,
641: USERENV('LANG'),
642: msii.change_line_id
643: from mtl_system_items_interface msii,
644: FND_LANGUAGES LANGS
645: where msii.set_process_id = p_batch_id
646: and msii.process_flag = l_process_flag
647: -- and msii.transaction_type=L_TRANSACTION_TYPE

Line 690: ' , FND_GLOBAL.USER_ID FROM MTL_SYSTEM_ITEMS_INTERFACE MSII';

686: l_dynamic_sql := l_dynamic_sql ||
687: ' , ' || l_sub_desc_array(sub_count).SUBJECT_LEVEL ||
688: ' , FND_GLOBAL.USER_ID, SYSDATE ' ||
689: ' , FND_GLOBAL.USER_ID, SYSDATE'||
690: ' , FND_GLOBAL.USER_ID FROM MTL_SYSTEM_ITEMS_INTERFACE MSII';
691:
692: if l_sub_desc_array(sub_count).ENTITY_NAME = 'EGO_ITEM_REVISION'
693: then
694: l_dynamic_sql := l_dynamic_sql ||' ,MTL_ITEM_REVISIONS_INTERFACE MIRI '||