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 ENG_CHANGE_ORDER_TYPES_VL

Line 92: FROM eng_change_order_types_vl ecotv1, eng_change_order_types_vl ecotv2

88: SELECT ecotv1.change_order_type_id change_mgmt_type_id,
89: ecotv2.change_order_type_id,
90: ecotv2.auto_numbering_method,
91: ecotv1.auto_numbering_method change_mgmt_method
92: FROM eng_change_order_types_vl ecotv1, eng_change_order_types_vl ecotv2
93: WHERE ecotv1.change_order_type_id = l_change_order_type_id
94: AND ecotv1.TYPE_CLASSIFICATION= 'CATEGORY'
95: AND ecotv1.change_mgmt_type_code = ecotv2.change_mgmt_type_code
96: AND ecotv2.type_name = change_type_code

Line 167: FROM ENG_CHANGE_ORDER_TYPES_VL

163:
164:
165: select change_order_type, change_order_type_id
166: into change_mgmt_type_name, l_change_order_type_id
167: FROM ENG_CHANGE_ORDER_TYPES_VL
168: WHERE change_mgmt_type_code='NEW_ITEM_REQUEST'
169: AND type_classification='CATEGORY';
170:
171: l_eco_rec.change_management_type := change_mgmt_type_name;

Line 364: ENG_CHANGE_ORDER_TYPES_VL eng_types,

360: l_change_type_array,
361: l_org_array
362: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
363: MTL_ITEM_CATALOG_GROUPS_VL micg,
364: ENG_CHANGE_ORDER_TYPES_VL eng_types,
365: MTL_PARAMETERS mp
366: WHERE msii.set_process_id=P_BATCH_ID
367: AND PROCESS_FLAG = l_process_flag
368: AND msii.ITEM_CATALOG_GROUP_ID = micg.ITEM_CATALOG_GROUP_ID

Line 401: ENG_CHANGE_ORDER_TYPES_VL eng_types,

397: BULK COLLECT INTO l_icc_array ,
398: l_change_type_array,
399: l_org_array
400: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
401: ENG_CHANGE_ORDER_TYPES_VL eng_types,
402: MTL_PARAMETERS mp,
403: ego_item_cat_denorm_hier heir,
404: mtl_item_catalog_groups_b micgb
405: WHERE msii.set_process_id = P_BATCH_ID

Line 462: SELECT eng_types.type_name into l_change_type_code FROM ENG_CHANGE_ORDER_TYPES_VL eng_types WHERE eng_types.change_order_type_id = l_change_type_code_num;

458: l_prev_org_id := l_org_id;
459: end if;
460:
461: l_change_type_code_num := TO_NUMBER(SUBSTR(l_change_type_array(i), INSTR(l_change_type_array(i), '$$', 2)+2));
462: SELECT eng_types.type_name into l_change_type_code FROM ENG_CHANGE_ORDER_TYPES_VL eng_types WHERE eng_types.change_order_type_id = l_change_type_code_num;
463:
464: Create_New_Item_Request( x_return_status => l_return_status,
465: x_change_id => l_change_id,
466: change_number => l_icc_array(i),

Line 551: SELECT eng_types.type_name into l_change_type_code FROM ENG_CHANGE_ORDER_TYPES_VL eng_types WHERE eng_types.change_order_type_id = l_change_type_code_num;

547: AND PROCESS_FLAG = l_process_flag
548: -- AND TRANSACTION_TYPE =L_TRANSACTION_TYPE
549: ;
550: l_change_type_code_num := TO_NUMBER(SUBSTR(l_change_type_array(i), INSTR(l_change_type_array(i), '$$', 2)+2));
551: SELECT eng_types.type_name into l_change_type_code FROM ENG_CHANGE_ORDER_TYPES_VL eng_types WHERE eng_types.change_order_type_id = l_change_type_code_num;
552: for x in l_item_ids_array.FIRST .. l_item_ids_array.LAST
553: loop
554:
555: