APPS.EAM_ASSET_ATTR_IMPORT_PVT dependencies on MTL_EAM_ASSET_ATTR_VALUES

Line 63: l_descriptive_flexfield_name CONSTANT VARCHAR2(30) := 'MTL_EAM_ASSET_ATTR_VALUES';

59: l_exists_count NUMBER;
60:
61: l_application_id CONSTANT NUMBER := 401;
62: l_application_code CONSTANT VARCHAR2(3) := 'INV';
63: l_descriptive_flexfield_name CONSTANT VARCHAR2(30) := 'MTL_EAM_ASSET_ATTR_VALUES';
64:
65: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;
66: l_commit VARCHAR2(1) := fnd_api.g_false;
67: l_validation_level NUMBER := fnd_api.g_valid_level_full;

Line 368: FROM MTL_EAM_ASSET_ATTR_VALUES meaav

364:
365: -- before executing create, make sure that duplicate do not exists.
366: SELECT count(*)
367: INTO l_exists_count
368: FROM MTL_EAM_ASSET_ATTR_VALUES meaav
369: WHERE meaav.maintenance_object_type = 3
370: AND meaav.maintenance_object_id = l_instance_id
371: AND meaav.application_id = attr_group.application_id
372: AND meaav.descriptive_flexfield_name = attr_group.descriptive_flexfield_name

Line 396: FROM MTL_EAM_ASSET_ATTR_VALUES meaav

392:
393: BEGIN
394: SELECT meaav.rowid
395: INTO l_rowid
396: FROM MTL_EAM_ASSET_ATTR_VALUES meaav
397: WHERE meaav.maintenance_object_type = 3
398: AND meaav.maintenance_object_id = l_instance_id
399: AND meaav.application_id = attr_group.application_id
400: AND meaav.descriptive_flexfield_name = attr_group.descriptive_flexfield_name

Line 555: -- in the interface table from the base table mtl_eam_asset_attr_values

551:
552:
553: IF ( p_import_mode = 1) THEN -- Update Mode
554: -- Populate flex validation API with segment values that are missing
555: -- in the interface table from the base table mtl_eam_asset_attr_values
556:
557: FOR missing_attr IN missing_attr_cur
558: (
559: attr_group.application_id,

Line 574: l_sql_stmt1 := l_sql_stmt1 || ' FROM MTL_EAM_ASSET_ATTR_VALUES meaav '

570: l_sql_stmt1 := 'SELECT to_char(meaav.'|| missing_attr.application_column_name ||', ''yyyy-mm-dd'')' ;
571: ELSE
572: l_sql_stmt1 := 'SELECT meaav.'|| missing_attr.application_column_name ;
573: END IF;
574: l_sql_stmt1 := l_sql_stmt1 || ' FROM MTL_EAM_ASSET_ATTR_VALUES meaav '
575: || ' WHERE meaav.maintenance_object_type =3 and maintenance_object_id = :instance_id '
576: || ' AND meaav.application_id = :application_id '
577: || ' AND meaav.descriptive_flexfield_name = :descriptive_flexfield_name '
578: || ' AND meaav.attribute_category = :attribute' ;