APPS.WMS_DEVICE_INTEGRATION_PVT dependencies on MTL_PARAMETERS

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

942: wdr.serial_number serial,
943: wdr.status_msg STATUSMSG, wdr.last_update_date timestamp,
944: wdr.business_event_id bus_event_id
945: FROM wms_device_requests wdr, mfg_lookups ml1, mfg_lookups ml2,
946: wms_devices_vl wd, mtl_parameters mp1, mtl_item_locations_kfv milk1,
947: mtl_parameters mp2, mtl_item_locations_kfv milk2, wms_license_plate_numbers wlpn,
948: mtl_system_items_kfv msik
949: WHERE ml1.lookup_type(+)= 'WMS_TASK_TYPES' AND ml1.lookup_code(+) = wdr.task_type_id
950: AND ml2.lookup_type(+)='WMS_BUS_EVENT_TYPES'

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

943: wdr.status_msg STATUSMSG, wdr.last_update_date timestamp,
944: wdr.business_event_id bus_event_id
945: FROM wms_device_requests wdr, mfg_lookups ml1, mfg_lookups ml2,
946: wms_devices_vl wd, mtl_parameters mp1, mtl_item_locations_kfv milk1,
947: mtl_parameters mp2, mtl_item_locations_kfv milk2, wms_license_plate_numbers wlpn,
948: mtl_system_items_kfv msik
949: WHERE ml1.lookup_type(+)= 'WMS_TASK_TYPES' AND ml1.lookup_code(+) = wdr.task_type_id
950: AND ml2.lookup_type(+)='WMS_BUS_EVENT_TYPES'
951: AND ml2.lookup_code(+) = wdr.business_event_id

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

979: wdr.lot_qty||l_seperator||
980: wdr.serial_number||l_seperator||wdr.status_msg||l_seperator||wdr.last_update_date
981: CSV_LINE
982: FROM wms_device_requests wdr, mfg_lookups ml1, mfg_lookups ml2,
983: wms_devices_vl wd, mtl_parameters mp1, mtl_item_locations_kfv milk1,
984: mtl_parameters mp2, mtl_item_locations_kfv milk2, wms_license_plate_numbers wlpn,wms_license_plate_numbers wlpn1, --Added for Bug#8512121
985: mtl_system_items_kfv msik
986: WHERE ml1.lookup_type(+) = 'WMS_TASK_TYPES' AND ml1.lookup_code(+) = wdr.task_type_id
987: AND ml2.lookup_type(+)='WMS_BUS_EVENT_TYPES'

Line 984: mtl_parameters mp2, mtl_item_locations_kfv milk2, wms_license_plate_numbers wlpn,wms_license_plate_numbers wlpn1, --Added for Bug#8512121

980: wdr.serial_number||l_seperator||wdr.status_msg||l_seperator||wdr.last_update_date
981: CSV_LINE
982: FROM wms_device_requests wdr, mfg_lookups ml1, mfg_lookups ml2,
983: wms_devices_vl wd, mtl_parameters mp1, mtl_item_locations_kfv milk1,
984: mtl_parameters mp2, mtl_item_locations_kfv milk2, wms_license_plate_numbers wlpn,wms_license_plate_numbers wlpn1, --Added for Bug#8512121
985: mtl_system_items_kfv msik
986: WHERE ml1.lookup_type(+) = 'WMS_TASK_TYPES' AND ml1.lookup_code(+) = wdr.task_type_id
987: AND ml2.lookup_type(+)='WMS_BUS_EVENT_TYPES'
988: AND ml2.lookup_code(+) = wdr.business_event_id

Line 1897: from WMS_DEVICES_B d, mtl_parameters p

1893: END IF;
1894:
1895: select d.OUTPUT_METHOD_ID, p.WCS_ENABLED
1896: into l_deviotype, l_wcs_enabled
1897: from WMS_DEVICES_B d, mtl_parameters p
1898: where d.device_id = l_cur_dev.device_id
1899: and p.organization_id = d.organization_id;
1900:
1901:

Line 2434: from WMS_DEVICES_B d, mtl_parameters p

2430: END IF;
2431:
2432: select d.OUTPUT_METHOD_ID, p.WCS_ENABLED
2433: into l_deviotype, l_wcs_enabled
2434: from WMS_DEVICES_B d, mtl_parameters p
2435: where d.device_id = l_cur_dev.device_id
2436: and p.organization_id = d.organization_id;
2437:
2438:

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

2653: END IF;
2654:
2655: ELSE--other business event
2656: BEGIN
2657: SELECT nvl(WCS_ENABLED,'N') into l_wcs_enabled FROM MTL_PARAMETERS
2658: WHERE ORGANIZATION_ID = (SELECT ORGANIZATION_ID
2659: FROM wms_device_requests_hist
2660: WHERE request_id = p_request_id
2661: AND status_code ='P'