APPS.AHL_PRD_LOV_SERVICE_PVT dependencies on MTL_MATERIAL_STATUSES

Line 3204: l_status_code mtl_material_statuses.status_code%type;

3200:
3201: --Local Variables for search results
3202: l_rownum NUMBER;
3203: l_status_id NUMBER;
3204: l_status_code mtl_material_statuses.status_code%type;
3205: l_status_desc mtl_material_statuses.description%type;
3206:
3207: BEGIN
3208:

Line 3205: l_status_desc mtl_material_statuses.description%type;

3201: --Local Variables for search results
3202: l_rownum NUMBER;
3203: l_status_id NUMBER;
3204: l_status_code mtl_material_statuses.status_code%type;
3205: l_status_desc mtl_material_statuses.description%type;
3206:
3207: BEGIN
3208:
3209: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3214: l_sql_string := l_sql_string || ' FROM mtl_material_statuses ';

3210:
3211: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
3212: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, status_id,';
3213: l_sql_string := l_sql_string || ' status_code, description ';
3214: l_sql_string := l_sql_string || ' FROM mtl_material_statuses ';
3215: l_sql_string := l_sql_string || ' WHERE enabled_flag = 1 ';
3216:
3217: --Get Dynamic Search Criteria
3218: l_criteria_tbl :=p_lov_input_rec.LovCriteriaTbl;