DBA Data[Home] [Help]

APPS.WMS_DEVICE_INTEGRATION_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 928: mtl_system_items_kfv msik

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

Line 965: mtl_system_items_kfv msik

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