DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_LOV dependencies on WMS_DEVICES_VL

Line 1067: FROM WMS_DEVICES_VL

1063: DEVICE_TYPE device_type,
1064: DESCRIPTION device_desc,
1065: DEVICE_ID device_id,
1066: SUBINVENTORY_CODE subinventory
1067: FROM WMS_DEVICES_VL
1068: WHERE SUBINVENTORY_CODE is not null
1069: and ORGANIZATION_ID = p_Organization_Id
1070: and NAME like (p_concat_segments)
1071: UNION ALL

Line 1097: FROM WMS_DEVICES_VL wdv, WMS_DEVICE_ASSIGNMENT_TEMP wdat

1093: wdv.DEVICE_TYPE device_type,
1094: wdv.DESCRIPTION device_desc,
1095: wdat.ASSIGNMENT_TEMP_ID temp_id,
1096: wdv.SUBINVENTORY_CODE subinventory
1097: FROM WMS_DEVICES_VL wdv, WMS_DEVICE_ASSIGNMENT_TEMP wdat
1098: WHERE
1099: wdat.EMPLOYEE_ID = p_Employee_Id
1100: and wdv.device_id = wdat.device_id
1101: and wdv.NAME like (p_concat_segments)