APPS.WSM_LBJ_INTERFACE_PVT dependencies on BOM_DEPT_RES_INSTANCES

Line 4699: from bom_dept_res_instances bdri

4695: is valid for the resource. Now modified the SQL to check whether given instance is valid for the
4696: department, resource combination */
4697: select 1
4698: into l_exists
4699: from bom_dept_res_instances bdri
4700: where bdri.resource_id = l_resource_id
4701: and bdri.department_id = l_department_id
4702: and bdri.instance_id = l_instance_id
4703: and NVL(bdri.serial_number, g_nvl_str) = NVL(l_serial_number, g_nvl_str);

Line 4711: from bom_dept_res_instances bdri

4707: select 1
4708: into l_exists
4709: from dual
4710: where exists( select instance_id
4711: from bom_dept_res_instances bdri
4712: where bdri.resource_id = l_resource_id
4713: and bdri.instance_id = l_instance_id
4714: and NVL(bdri.serial_number, g_nvl_str) = NVL(l_serial_number, g_nvl_str) );
4715: