DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_LOV dependencies on WMS_DEVICES_VL

Line 1137: FROM WMS_DEVICES_VL

1133: DEVICE_TYPE device_type,
1134: DESCRIPTION device_desc,
1135: DEVICE_ID device_id,
1136: SUBINVENTORY_CODE subinventory
1137: FROM WMS_DEVICES_VL
1138: WHERE SUBINVENTORY_CODE is not null
1139: and ORGANIZATION_ID = p_Organization_Id
1140: and NAME like (p_concat_segments)
1141: UNION ALL

Line 1167: FROM WMS_DEVICES_VL wdv, WMS_DEVICE_ASSIGNMENT_TEMP wdat

1163: wdv.DEVICE_TYPE device_type,
1164: wdv.DESCRIPTION device_desc,
1165: wdat.ASSIGNMENT_TEMP_ID temp_id,
1166: wdv.SUBINVENTORY_CODE subinventory
1167: FROM WMS_DEVICES_VL wdv, WMS_DEVICE_ASSIGNMENT_TEMP wdat
1168: WHERE
1169: wdat.EMPLOYEE_ID = p_Employee_Id
1170: and wdv.device_id = wdat.device_id
1171: and wdv.NAME like (p_concat_segments)