APPS.AHL_PRD_LOV_SERVICE_PVT dependencies on MFG_LOOKUPS

Line 1793: l_res_type MFG_LOOKUPS.MEANING%type;

1789: l_rownum NUMBER;
1790: l_res_id NUMBER;
1791: l_res_code BOM_RESOURCES.RESOURCE_CODE%type;
1792: l_desc BOM_RESOURCES.DESCRIPTION%type;
1793: l_res_type MFG_LOOKUPS.MEANING%type;
1794: l_UOM mtl_units_of_measure.unit_of_measure%type;
1795: l_dept_id NUMBER;
1796:
1797: BEGIN

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

1802: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, ';
1803: l_sql_string := l_sql_string || ' BR.RESOURCE_ID ,BR.RESOURCE_CODE, BR.description , ';
1804: l_sql_string := l_sql_string || ' MFGL.MEANING RESOURCE_TYPE,UOM.unit_of_measure, BDR.DEPARTMENT_ID ';
1805: l_sql_string := l_sql_string || ' FROM BOM_RESOURCES BR,BOM_DEPARTMENT_RESOURCES BDR, ';
1806: l_sql_string := l_sql_string || ' MFG_LOOKUPS MFGL, mtl_units_of_measure UOM ';
1807: l_sql_string := l_sql_string || ' WHERE UOM.uom_code(+) = BR.UNIT_OF_MEASURE ';
1808: l_sql_string := l_sql_string || ' AND BR.RESOURCE_ID = BDR.RESOURCE_ID ';
1809: l_sql_string := l_sql_string || ' AND MFGL.LOOKUP_TYPE(+) = ''BOM_RESOURCE_TYPE'' ';
1810: l_sql_string := l_sql_string || ' AND MFGL.LOOKUP_CODE(+) = BR.RESOURCE_TYPE ';