APPS.AHL_PRD_LOV_SERVICE_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 1939: l_UOM mtl_units_of_measure.unit_of_measure%type;

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:
1942: BEGIN
1943:

Line 1951: l_sql_string := l_sql_string || ' MFG_LOOKUPS MFGL, mtl_units_of_measure UOM ';

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'' ';
1955: l_sql_string := l_sql_string || ' AND MFGL.LOOKUP_CODE(+) = BR.RESOURCE_TYPE ';