DBA Data[Home] [Help]

APPS.WMS_DEVICE_INTEGRATION_PVT dependencies on MFG_LOOKUPS

Line 925: FROM wms_device_requests wdr, mfg_lookups ml1, mfg_lookups ml2,

921: wdr.uom UOM, wdr.lot_number LOT, wdr.lot_qty LOTQTY,
922: wdr.serial_number serial,
923: wdr.status_msg STATUSMSG, wdr.last_update_date timestamp,
924: wdr.business_event_id bus_event_id
925: FROM wms_device_requests wdr, mfg_lookups ml1, mfg_lookups ml2,
926: wms_devices_vl wd, mtl_parameters mp1, mtl_item_locations_kfv milk1,
927: mtl_parameters mp2, mtl_item_locations_kfv milk2, wms_license_plate_numbers wlpn,
928: mtl_system_items_kfv msik
929: WHERE ml1.lookup_type(+)= 'WMS_TASK_TYPES' AND ml1.lookup_code(+) = wdr.task_type_id

Line 962: FROM wms_device_requests wdr, mfg_lookups ml1, mfg_lookups ml2,

958: wdr.uom ||l_seperator|| wdr.lot_number ||l_seperator||
959: wdr.lot_qty||l_seperator||
960: wdr.serial_number||l_seperator||wdr.status_msg||l_seperator||wdr.last_update_date
961: CSV_LINE
962: FROM wms_device_requests wdr, mfg_lookups ml1, mfg_lookups ml2,
963: wms_devices_vl wd, mtl_parameters mp1, mtl_item_locations_kfv milk1,
964: mtl_parameters mp2, mtl_item_locations_kfv milk2, wms_license_plate_numbers wlpn,
965: mtl_system_items_kfv msik
966: WHERE ml1.lookup_type(+) = 'WMS_TASK_TYPES' AND ml1.lookup_code(+) = wdr.task_type_id