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.EAM_ASSET_ATTR_IMPORT_PVT dependencies on MTL_EAM_ATTR_VAL_INTERFACE

Line 134: FROM MTL_EAM_ATTR_VAL_INTERFACE meavi

130: SELECT DISTINCT meavi.application_id,
131: meavi.descriptive_flexfield_name,
132: meavi.attribute_category,
133: meavi.association_id
134: FROM MTL_EAM_ATTR_VAL_INTERFACE meavi
135: WHERE meavi.interface_header_id = p_interface_header_id
136: AND meavi.process_status = 'P';
137:
138: -- Cursor for every attribute in this processing group

Line 148: FROM MTL_EAM_ATTR_VAL_INTERFACE meavi

144: meavi.line_type,
145: meavi.attribute_varchar2_value,
146: meavi.attribute_number_value,
147: meavi.attribute_date_value
148: FROM MTL_EAM_ATTR_VAL_INTERFACE meavi
149: WHERE meavi.interface_header_id = p_interface_header_id
150: AND meavi.application_id = l_application_id
151: AND meavi.descriptive_flexfield_name = l_descr_flexfield_name
152: AND meavi.attribute_category = l_descr_flex_context_code

Line 169: FROM mtl_eam_attr_val_interface meavi

165: AND fdfcu.application_id = l_application_id
166: AND fdfcu.application_column_name
167: NOT IN
168: (SELECT meavi.application_column_name
169: FROM mtl_eam_attr_val_interface meavi
170: WHERE meavi.interface_header_id = p_interface_header_id
171: AND meavi.application_id = l_application_id
172: AND meavi.descriptive_flexfield_name = l_descr_flexfield_name
173: AND meavi.attribute_category = l_descr_flex_context_code

Line 209: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi

205:
206:
207:
208: -- 2002-01-02: chrng: To fix bug 2167188, check that derived columns are NULL.
209: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi
210: SET meavi.error_number = 9999,
211: meavi.process_status = 'E',
212: meavi.error_message = 'Derived column APPLICATION_ID should be NULL'
213: WHERE meavi.interface_header_id = p_interface_header_id

Line 217: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi

213: WHERE meavi.interface_header_id = p_interface_header_id
214: AND meavi.process_status = 'P'
215: AND meavi.application_id IS NOT NULL;
216:
217: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi
218: SET meavi.error_number = 9999,
219: meavi.process_status = 'E',
220: meavi.error_message = 'Derived column DESCRITIVE_FLEXFIELD_NAME should be NULL'
221: WHERE meavi.interface_header_id = p_interface_header_id

Line 225: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi

221: WHERE meavi.interface_header_id = p_interface_header_id
222: AND meavi.process_status = 'P'
223: AND meavi.descriptive_flexfield_name IS NOT NULL;
224:
225: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi
226: SET meavi.error_number = 9999,
227: meavi.process_status = 'E',
228: meavi.error_message = 'Derived column APPLICATION_COLUMN_NAME should be NULL'
229: WHERE meavi.interface_header_id = p_interface_header_id

Line 233: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi

229: WHERE meavi.interface_header_id = p_interface_header_id
230: AND meavi.process_status = 'P'
231: AND meavi.application_column_name IS NOT NULL;
232:
233: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi
234: SET meavi.error_number = 9999,
235: meavi.process_status = 'E',
236: meavi.error_message = 'Derived column ASSOCIATION_ID should be NULL'
237: WHERE meavi.interface_header_id = p_interface_header_id

Line 244: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi

240:
241:
242: -- Update all rows for this set with proper application_id and Desc Flex Name
243:
244: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi
245: SET meavi.application_id = l_application_id,
246: meavi.descriptive_flexfield_name = l_descriptive_flexfield_name
247: WHERE meavi.interface_header_id = p_interface_header_id
248: AND meavi.process_status = 'P';

Line 252: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi

248: AND meavi.process_status = 'P';
249:
250: -- validate flexfield details from Desc FlexField Column Usages Table
251:
252: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi
253: SET meavi.error_number = 9999,
254: meavi.process_status = 'E',
255: meavi.error_message = 'Decriptive Flexfield Details are Invalid'
256: WHERE meavi.interface_header_id = p_interface_header_id

Line 271: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi

267: AND meavi.interface_header_id = p_interface_header_id);
268:
269: -- Obtain the application column name for each row in the interface table
270:
271: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi
272: SET meavi.application_column_name = EAM_ASSET_SEARCH_PVT.GET_ATTRIBUTE_COLUMN_NAME
273: (meavi.application_id,
274: meavi.descriptive_flexfield_name,
275: meavi.attribute_category,

Line 283: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi

279: AND meavi.process_status = 'P';
280:
281: -- Mark rows as error is application column name is NULL
282:
283: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi
284: SET meavi.error_number = 9999,
285: meavi.process_status = 'E',
286: meavi.error_message = 'Application Column Name not found'
287: WHERE meavi.interface_header_id = p_interface_header_id

Line 293: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi

289: AND meavi.application_column_name IS NULL;
290:
291: -- Obtain associationId if available from asset atribute groups table
292:
293: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi
294: SET (meavi.association_id) =
295: (SELECT meaag.association_id
296: FROM MTL_EAM_ASSET_ATTR_GROUPS meaag,
297: MTL_EAM_ASSET_NUM_INTERFACE meani

Line 309: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi

305: AND meavi.process_status = 'P';
306:
307: -- 2001-12-28: chrng: To fix bug 2156429, flag rows without association_id
308: -- (Attribute Group not associated with Asset Group) as Error.
309: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi
310: SET meavi.error_number = 9999,
311: meavi.process_status = 'E',
312: meavi.error_message = 'Attribute Group not associated with Asset Group'
313: WHERE meavi.interface_header_id = p_interface_header_id

Line 320: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi

316:
317:
318: -- 2001-12-26: chrng: To fix bug 2156483, check line_type not out-of-range
319: -- Validate line_type
320: UPDATE MTL_EAM_ATTR_VAL_INTERFACE meavi
321: SET meavi.error_number = 9999,
322: meavi.process_status = 'E',
323: meavi.error_message = 'line_type must be 1 (VARCHAR2), 2 (NUMBER), or 3 (DATE)'
324: WHERE meavi.interface_header_id = p_interface_header_id

Line 377: UPDATE mtl_eam_attr_val_interface meavi

373: AND meaav.attribute_category = attr_group.attribute_category;
374:
375: IF (l_exists_count >= 1 ) THEN
376:
377: UPDATE mtl_eam_attr_val_interface meavi
378: SET meavi.process_status = 'E',
379: meavi.error_number = 9999,
380: meavi.error_message = 'Attribute Group Already exists'
381: WHERE meavi.interface_header_id = p_interface_header_id

Line 409: UPDATE mtl_eam_attr_val_interface meavi

405: -- Error if Attribute Group does not exist
406: WHEN NO_DATA_FOUND
407: THEN
408:
409: UPDATE mtl_eam_attr_val_interface meavi
410: SET meavi.process_status = 'E',
411: meavi.error_number = 9999,
412: meavi.error_message = 'Attribute Group does not exist'
413: WHERE meavi.interface_header_id = p_interface_header_id

Line 622: UPDATE mtl_eam_attr_val_interface meavi

618: 'I',
619: SYSDATE)) THEN
620:
621: -- Value Set validation failed, mark rows as error
622: UPDATE mtl_eam_attr_val_interface meavi
623: SET meavi.process_status = 'E',
624: meavi.error_number = 9999,
625: meavi.error_message = FND_FLEX_DESCVAL.error_message
626: WHERE meavi.interface_header_id = p_interface_header_id

Line 645: FROM mtl_eam_attr_val_interface meavi

641: -- Check if any attribute has failed. Even if one has failed, don't insert/update row.
642: DECLARE
643: CURSOR failed_meavi_row_cur IS
644: SELECT meavi.interface_line_id
645: FROM mtl_eam_attr_val_interface meavi
646: WHERE meavi.interface_header_id = p_interface_header_id
647: AND meavi.application_id = attr_group.application_id
648: AND meavi.descriptive_flexfield_name = attr_group.descriptive_flexfield_name
649: AND meavi.attribute_category = attr_group.attribute_category

Line 845: UPDATE mtl_eam_attr_val_interface meavi

841: END IF;
842:
843: END IF;
844:
845: UPDATE mtl_eam_attr_val_interface meavi
846: SET meavi.process_status = 'S',
847: meavi.error_number = NULL,
848: meavi.error_message = 'Success'
849: WHERE meavi.interface_header_id = p_interface_header_id

Line 885: FROM mtl_eam_attr_val_interface meavi

881: -- Even if one has failed, fail the whole procedure.
882: DECLARE
883: CURSOR all_failed_meavi_row_cur IS
884: SELECT meavi.interface_line_id
885: FROM mtl_eam_attr_val_interface meavi
886: WHERE meavi.interface_header_id = p_interface_header_id
887: -- Since the following fields can have errors
888: -- AND meavi.application_id = l_application_id
889: -- AND meavi.descriptive_flexfield_name = l_descriptive_flexfield_name

Line 930: DELETE MTL_EAM_ATTR_VAL_INTERFACE meavi

926:
927: -- Purge Search Criteria from Temp table
928: IF p_purge_option = 'Y' THEN
929:
930: DELETE MTL_EAM_ATTR_VAL_INTERFACE meavi
931: WHERE meavi.interface_header_id = p_interface_header_id
932: AND ERROR_NUMBER IS NULL
933: AND PROCESS_STATUS = 'S';
934: END IF;

Line 958: UPDATE mtl_eam_attr_val_interface meavi

954:
955: WHEN attr_import_failed THEN
956: -- Update all records as error if one of the attributes rows have errored out
957: -- within any attribute group of the asset
958: UPDATE mtl_eam_attr_val_interface meavi
959: SET meavi.process_status = 'E',
960: meavi.error_number = 9999,
961: meavi.error_message = 'Failed as another Attribute of this Asset Number has failed validation'
962: WHERE meavi.interface_header_id = p_interface_header_id

Line 971: FROM mtl_eam_attr_val_interface meavi

967: -- AND meavi.process_status = 'P'
968: AND meavi.error_number IS NULL
969: AND EXISTS(
970: SELECT meavi.process_status
971: FROM mtl_eam_attr_val_interface meavi
972: WHERE meavi.interface_header_id = p_interface_header_id
973: AND meavi.application_id = l_application_id
974: AND meavi.descriptive_flexfield_name = l_descriptive_flexfield_name
975: -- AND meavi.attribute_category = attr_group.attribute_category