DBA Data[Home] [Help]

APPS.WMS_DEVICE_INTEGRATION_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 948: mtl_system_items_kfv msik

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
952: AND wd.device_id = wdr.device_id AND mp1.organization_id = wdr.organization_id

Line 985: mtl_system_items_kfv msik

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
989: AND wd.device_id = wdr.device_id AND mp1.organization_id = wdr.organization_id