APPS.AHL_PRD_LOV_SERVICE_PVT dependencies on BOM_RESOURCES

Line 1936: l_res_code BOM_RESOURCES.RESOURCE_CODE%type;

1932:
1933: --Local Variables for search results
1934: l_rownum NUMBER;
1935: l_res_id NUMBER;
1936: l_res_code BOM_RESOURCES.RESOURCE_CODE%type;
1937: l_desc BOM_RESOURCES.DESCRIPTION%type;
1938: l_res_type MFG_LOOKUPS.MEANING%type;
1939: l_UOM mtl_units_of_measure.unit_of_measure%type;
1940: l_dept_id NUMBER;

Line 1937: l_desc BOM_RESOURCES.DESCRIPTION%type;

1933: --Local Variables for search results
1934: l_rownum NUMBER;
1935: l_res_id NUMBER;
1936: l_res_code BOM_RESOURCES.RESOURCE_CODE%type;
1937: l_desc BOM_RESOURCES.DESCRIPTION%type;
1938: l_res_type MFG_LOOKUPS.MEANING%type;
1939: l_UOM mtl_units_of_measure.unit_of_measure%type;
1940: l_dept_id NUMBER;
1941:

Line 1950: l_sql_string := l_sql_string || ' FROM BOM_RESOURCES BR,BOM_DEPARTMENT_RESOURCES BDR, ';

1946: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
1947: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, ';
1948: l_sql_string := l_sql_string || ' BR.RESOURCE_ID ,BR.RESOURCE_CODE, BR.description , ';
1949: l_sql_string := l_sql_string || ' MFGL.MEANING RESOURCE_TYPE,UOM.unit_of_measure, BDR.DEPARTMENT_ID ';
1950: l_sql_string := l_sql_string || ' FROM BOM_RESOURCES BR,BOM_DEPARTMENT_RESOURCES BDR, ';
1951: l_sql_string := l_sql_string || ' MFG_LOOKUPS MFGL, mtl_units_of_measure UOM ';
1952: l_sql_string := l_sql_string || ' WHERE UOM.uom_code(+) = BR.UNIT_OF_MEASURE ';
1953: l_sql_string := l_sql_string || ' AND BR.RESOURCE_ID = BDR.RESOURCE_ID ';
1954: l_sql_string := l_sql_string || ' AND MFGL.LOOKUP_TYPE(+) = ''BOM_RESOURCE_TYPE'' ';