APPS.WMS_DEVICE_INTEGRATION_PVT dependencies on MTL_PARAMETERS

Line 926: wms_devices_vl wd, mtl_parameters mp1, mtl_item_locations_kfv milk1,

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
930: AND ml2.lookup_type(+)='WMS_BUS_EVENT_TYPES'

Line 927: mtl_parameters mp2, mtl_item_locations_kfv milk2, wms_license_plate_numbers wlpn,

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
930: AND ml2.lookup_type(+)='WMS_BUS_EVENT_TYPES'
931: AND ml2.lookup_code(+) = wdr.business_event_id

Line 963: wms_devices_vl wd, mtl_parameters mp1, mtl_item_locations_kfv milk1,

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
967: AND ml2.lookup_type(+)='WMS_BUS_EVENT_TYPES'

Line 964: mtl_parameters mp2, mtl_item_locations_kfv milk2, wms_license_plate_numbers wlpn,

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
967: AND ml2.lookup_type(+)='WMS_BUS_EVENT_TYPES'
968: AND ml2.lookup_code(+) = wdr.business_event_id

Line 1815: from WMS_DEVICES_B d, mtl_parameters p

1811: END IF;
1812:
1813: select d.OUTPUT_METHOD_ID, p.WCS_ENABLED
1814: into l_deviotype, l_wcs_enabled
1815: from WMS_DEVICES_B d, mtl_parameters p
1816: where d.device_id = l_cur_dev.device_id
1817: and p.organization_id = d.organization_id;
1818:
1819:

Line 2350: from WMS_DEVICES_B d, mtl_parameters p

2346: END IF;
2347:
2348: select d.OUTPUT_METHOD_ID, p.WCS_ENABLED
2349: into l_deviotype, l_wcs_enabled
2350: from WMS_DEVICES_B d, mtl_parameters p
2351: where d.device_id = l_cur_dev.device_id
2352: and p.organization_id = d.organization_id;
2353:
2354:

Line 2573: SELECT nvl(WCS_ENABLED,'N') into l_wcs_enabled FROM MTL_PARAMETERS

2569: END IF;
2570:
2571: ELSE--other business event
2572: BEGIN
2573: SELECT nvl(WCS_ENABLED,'N') into l_wcs_enabled FROM MTL_PARAMETERS
2574: WHERE ORGANIZATION_ID = (SELECT ORGANIZATION_ID
2575: FROM wms_device_requests_hist
2576: WHERE request_id = p_request_id
2577: AND status_code ='P'