APPS.AHL_PRD_LOV_SERVICE_PVT dependencies on BOM_DEPARTMENTS

Line 161: l_dept BOM_DEPARTMENTS.description%type;

157: l_visit_type fnd_lookup_values_vl.meaning%type;
158: l_item MTL_SYSTEM_ITEMS_KFV.concatenated_segments%type;
159: l_serial_number CSI_ITEM_INSTANCES.serial_number%type;
160: l_org HR_ALL_ORGANIZATION_UNITS.name%type;
161: l_dept BOM_DEPARTMENTS.description%type;
162: l_unit ahl_unit_config_headers.name%type;
163:
164: BEGIN
165:

Line 178: l_sql_string := l_sql_string || ' BOM_DEPARTMENTS BDPT ';

174:
175: l_sql_string := l_sql_string || ' FROM ahl_visits_b vst, AHL_SIMULATION_PLANS_B ASML, ';
176: l_sql_string := l_sql_string || ' fnd_lookup_values_vl fndvt, MTL_SYSTEM_ITEMS_KFV MTSB, ';
177: l_sql_string := l_sql_string || ' CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS HROU, ';
178: l_sql_string := l_sql_string || ' BOM_DEPARTMENTS BDPT ';
179:
180: l_sql_string := l_sql_string || ' WHERE vst.simulation_plan_id = asml.simulation_plan_id AND ';
181: l_sql_string := l_sql_string || ' ASML.PRIMARY_PLAN_FLAG = ''Y'' AND ';
182: l_sql_string := l_sql_string || ' vst.status_code not in ( ''PLANNING'', ''DELETED'' ) AND ';