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 154: FROM ENG_CHANGE_ORDER_TYPES_VL

150:
151:
152: select change_order_type, change_order_type_id
153: into change_mgmt_type_name, l_change_order_type_id
154: FROM ENG_CHANGE_ORDER_TYPES_VL
155: WHERE change_mgmt_type_code='NEW_ITEM_REQUEST'
156: AND type_classification='CATEGORY';
157:
158: l_eco_rec.change_management_type := change_mgmt_type_name;

Line 347: ENG_CHANGE_ORDER_TYPES_VL eng_types,

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
350: AND PROCESS_FLAG = l_process_flag
351: AND msii.ITEM_CATALOG_GROUP_ID = micg.ITEM_CATALOG_GROUP_ID

Line 383: ENG_CHANGE_ORDER_TYPES_VL eng_types,

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
387: WHERE msii.set_process_id = P_BATCH_ID