APPS.EAM_ASSET_SEARCH_PVT dependencies on MTL_EAM_ASSET_SEARCH_TEMP

Line 29: -- mtl_eam_asset_search_temp table.

25: -- Version Initial version 1.0
26: --
27: -- Notes : This API Build the dynamic SQL to retrieve the Asset Numbers based on
28: -- extensible attributes criteria as identified by the search_set_id in
29: -- mtl_eam_asset_search_temp table.
30: -- ****** Sample Output statement of the API ***********
31: --
32: -- SELECT MAEAV.INVENTORY_ITEM_ID, MAEAV.SERIAL_NUMBER, MAEAV.ORGANIZATION_ID
33: -- FROM MTL_EAM_ASSET_ATTR_VALUES MAEAV

Line 78: FROM MTL_EAM_ASSET_SEARCH_TEMP meast

74: l_line_type_counter NUMBER;
75:
76: CURSOR context_cur IS
77: SELECT DISTINCT meast.descriptive_flex_context_code AS DESCR_CONTEXT_CODE
78: FROM MTL_EAM_ASSET_SEARCH_TEMP meast
79: WHERE meast.SEARCH_SET_ID = p_search_set_id;
80:
81: CURSOR attribute_cur (l_context_code VARCHAR2, l_line_type NUMBER) IS
82: SELECT meast.end_user_column_name END_USER_COLUMN_NAME,

Line 88: FROM MTL_EAM_ASSET_SEARCH_TEMP meast

84: meast.line_type LINE_TYPE,
85: meast.attribute_varchar2_value ATTRIBUTE_VARCHAR2_VALUE,
86: meast.attribute_number_value ATTRIBUTE_NUMBER_VALUE,
87: meast.attribute_date_value ATTRIBUTE_DATE_VALUE
88: FROM MTL_EAM_ASSET_SEARCH_TEMP meast
89: WHERE meast.SEARCH_SET_ID = p_search_set_id
90: AND meast.DESCRIPTIVE_FLEX_CONTEXT_CODE = l_context_code
91: AND meast.line_type = l_line_type;
92:

Line 225: DELETE MTL_EAM_ASSET_SEARCH_TEMP

221:
222: l_stmt_num := 150;
223: -- Purge Search Criteria from Temp table
224: IF fnd_api.to_boolean(p_purge_option) THEN
225: DELETE MTL_EAM_ASSET_SEARCH_TEMP
226: WHERE SEARCH_SET_ID = p_search_set_id;
227: END IF;
228:
229: