3346:
3347: --Local Variables for search results
3348: l_rownum NUMBER;
3349: l_status_id NUMBER;
3350: l_status_code mtl_material_statuses.status_code%type;
3351: l_status_desc mtl_material_statuses.description%type;
3352:
3353: BEGIN
3354:
3347: --Local Variables for search results
3348: l_rownum NUMBER;
3349: l_status_id NUMBER;
3350: l_status_code mtl_material_statuses.status_code%type;
3351: l_status_desc mtl_material_statuses.description%type;
3352:
3353: BEGIN
3354:
3355: x_return_status := FND_API.G_RET_STS_SUCCESS;
3356:
3357: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
3358: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, status_id,';
3359: l_sql_string := l_sql_string || ' status_code, description ';
3360: l_sql_string := l_sql_string || ' FROM mtl_material_statuses ';
3361: l_sql_string := l_sql_string || ' WHERE enabled_flag = 1 ';
3362:
3363: --Get Dynamic Search Criteria
3364: l_criteria_tbl :=p_lov_input_rec.LovCriteriaTbl;