APPS.WSM_LBJ_INTERFACE_PVT dependencies on BOM_DEPT_RES_INSTANCES

Line 4704: from bom_dept_res_instances bdri

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

Line 4716: from bom_dept_res_instances bdri

4712: select 1
4713: into l_exists
4714: from dual
4715: where exists( select instance_id
4716: from bom_dept_res_instances bdri
4717: where bdri.resource_id = l_resource_id
4718: and bdri.instance_id = l_instance_id
4719: and NVL(bdri.serial_number, g_nvl_str) = NVL(l_serial_number, g_nvl_str) );
4720: